Dim db as Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try setting up the Dim statement for a database object, I do not have
the database object in my list of available objects.

I think I need additional files installed, but can not find them on disk one
of the Office 2000 disk. Is this info on Disk 2?
 
You just need to set a reference to the DAO library (it's not set by default
in ACCESS 2000 and 2002). Open Visual Basic Editor, click Tools |
References, and select the Data Access Object library (3.6).

Note that DAO and ADO have some objects with the same names (e.g.,
Recordset), so disambiguate any DAO objects using DAO. in the declaration.
 
Thanks Ken That is exactly what I was looking for. I am an Office 97 user
and I never had to do that. Now I know for future use.
 
Back
Top