Access 2007 - whatever happened to ADO and DAO ?

[Sreedhar]

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 ?

Thanks.

 

[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 http://www.allenbrowne.com/ser-38.html 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.

 

[Sreedhar]

Hi,

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 ?

 

[Douglas J. Steele]

AFAIK, the object model for ACE is identical to the DAO object model.

 

[Sreedhar]

Hi Doug,

Just found this: http://msdn.microsoft.com/en-us/library/bb244895.aspx

Just wanted to share, in case someone needs to know.....

Thanks again for your time and patient reply.