Access 2007 - whatever happened to ADO and DAO ?



Hi everyone,

I've recently upgraded to Access 2007. I can't understand VBA references
quite well in the new version. Can somebody please tell what "Microsoft
Office 12.0 Access database engine Object Library" stands for ?

If I've to use ADO or DAO, why should I explicitly set a reference to that
library ? Access 2003 sets the reference for me. Why not here ?

My preference is DAO and I used to uncheck the reference to ADO in Access
2003. What references should be set as a standard in Access 2007 ?


Douglas J. Steele

Microsoft Office 12.0 Access database engine Object Library is the
equivalent of DAO if you're using the ACCDB format. If you're still using
the MDB format, continue to use Microsoft DAO 3.6 Object Library.

ADO is the same reference regardless of which database format you're using:
Microsoft ActiveX Data Objects 2.x Library.

Check what Allen Browne has at for
details of the defaults.

If you're not using ADO, there's no point in having the ADO reference set.
In general, you always want to "starve" the references: never include
references you don't actually need.



Thanks for the reply. And Allen's site is really informative and helpful.

BTW, is the object model for "Office 12.0 Access database engine" any
different from earlier DAO 3.x Libraries ? Where can I get more info on this ?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question