Where is the DAO Library in Access 2007 and 2010?

User Rating: 3 / 5

Star ActiveStar ActiveStar ActiveStar InactiveStar Inactive
 

 

In Access 2000 to 2003 to use DAO you needed to set a reference to the DAO Library

 

access2003dao

(Credit: Screenshot created with Techsmith's Snagit)

 

Starting with Access 2007 (12.0) and continuing in Access 2010 (14.0) there is a new Access Database Engine (ACE) that replaces the older JET database engine. DAO is now built into ACE. By default Access sets a reference to this new object library called Microsoft Office 12.0 Access database engine Object Library.

 

msofficeaceobject2007b

(Credit: Screenshot created with Techsmith's Snagit)

 

You should not set a reference to the older DAO 3.x object libraries in Access 2007 or Access 2010. You should use the new DAO library built into the Microsoft Office 12.0/14.0 Access Database Engine Object Library.