Microsoft Most Valued Professional MVP - Access Expert


  Boyd Trimmell, aka HiTech Coach
  Microsoft MVP - Access Expert

What is a Microsoft  Most Valuable Professional (MVP)?
Microsoft  awards the Most Valuable Professional (MVP) in recognition of significant contributions made to technical communities by sharing high quality, real world expertise. Microsoft Most Valuable Professionals (MVPs) are a worldwide network of exceptional technical community leaders.

"If technology doesn't work for people, then it doesn't work."
- Kim Vicente

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



(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.



(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.