Reference Libraries

  • Thread starter Thread starter S Jackson
  • Start date Start date
S

S Jackson

Whenever I try to type this:

Dim db As Database

Database is not in the list of choices. The library references I have
listed are:

Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

Are these the references that are set by default when Access is installed?

Obviously, I am missing a needed reference library, no? What library? I
have two MS DAO libraries: DAO 3.51 and DAO 3.6. Is it one of these that I
need a reference to?

If I add a reference to one of these libraries in order to use the Dim db As
Database, does that mean other users with a copy of the db will need to set
that reference too in order for the code to work? How can I avoid this?
Other users will be spread across the state and I do not have access to
their computers.

TIA
S Jackson
 
For Access 97, you would use the DAO 3.51 Lib. Since I see you have a
reference to the MS Access 9.0 Obj Library (Access 2000 - correct?), you
would select the Microsoft DAO 3.6 Object Library.

hth,
 
The references are stored in your database file so other users who use a
copy of your database will be fine (provided that they have A2K/AXP and DAO
3.6 installed on their PC).

Also, if you don't use ADO coding, then remove it from the References of
your database.
 
Back
Top