Which reference libraries should i check

  • Thread starter Thread starter Del J
  • Start date Start date
D

Del J

By default my Access application has the following libraries checked in the
Tools/References of the VBE:
Visual Basic for Applications
MS Access 9.0 Object Library
OLE Automation
MS ActiveX Data Objects 2.1 Library

While going through Beginning Access 2000 VBA to improve my programming
abilities i ran across a section that told me to uncheck the MS ActiveX Data
Objects 2.1 Library and check MS DAO 2.6 Object Library.

i confess a lot of ignorance in this area. Can someone give me some good
advice here?
 
The best approach is to use only the library references you really need for
your project.

Access and VBA are required (i.e. you cannot remove those.) DAO is the
native library designed for Access, so you generally need that. ADO is more
generic, so you might use that if connecting to other data sources but is
not needed if your data is in Access tables. The others (including OLE
Automation) are only needed for other things.

For more info about which library references you need for each version of
Access, see:
Solving Problems with Library References
at:
http://allenbrowne.com/ser-38.html
 
Back
Top