Access
Where is the DAO Library in Access 2007, 2010, 2013, 2016 and later?
- Details
- Category: VBA VBA
- Created: 29 June 2011 29 June 2011
- Last Updated: 28 September 2021 28 September 2021
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), continuing in Access 2010 (14.0) and later versions 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.