DAO Objects Problem

[Sarah]

I keep having a problem with Access 2000 and Windows XP.
When I try to use DAO libraries, I get error messages.

 

[Wayne Morgan]

Have you set a Reference to DAO, Access 2000 uses ADO by default? In the
code window (Alt+F11) go to Tools|References. Is there a check next to
Microsoft DAO 3.6 Object Library? If not, scroll down and check it. Also,
make sure it isn't listed as Missing. To prevent confusion between DAO and
ADO, they have some common component names, specify the library in your Dim
statements.

Example:
Dim rst As DAO.Recordset

 

[Van T. Dinh]

1. What error message? The line of code that errors out?

2. Have you included the Microsoft DAO 3.6 Library in the References
Collection of your database?

3. If you have not removed the ADO 2.X Library, have you disambiguated the
declaration of Recordsets like:

Dim rst As DAO.Library

?
(Note: DAO Recordsets and ADO Recordsets are NOT compatible and if you don't
disambiguate, you may get ADO Recordset rather than the required DAO
Recordset)