Library removed solves problem - why?

[Guest]

I sent out my Access 2000 project to several people. Every now and then, I
will get a person whose computer will give them an error (I believe it is the
Object missing error). The solution has been to go into the VBA Library and
uncheck a reference to a certain library. I believe it was the Microsoft DAO
3.6 Object Library that I unchecked. I have had to do this a couple times.
Maybe someone could help me understand what might be going on. Also what are
librarys are considered standard for Access 2000.

 

[Ron Hinds]

You are probably using ADO (ActiveX Data Objects) in your project instead of
DAO (Data Access Objects). DAO is the Microsoft Jet Database Engine. If you
are able to remove the Reference to it and your app still works then you
must be using ADO. The reason some people might get errors is that they
don't have that library (DAO360.DLL) installed on their system. I believe
that DAO is the default data access method for Access 2000. Are you sure
that is what you unchecked?

 

[Douglas J. Steele]

Actually, Access 2000 (and 2002, for that matter) defaults to ADO, and
doesn't actually include the DAO reference (you must add it yourself if you
want to use DAO)

For a detailed discussion about References and Reference Problems, see
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

Allen Browne has details about the default references for each version of
Access at http://www.allenbrowne.com/ser-38.html