'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Microsoft DAO 3.6 Object Library Error in Access
Question details
The user is experiencing a DLL loading failure related to the Microsoft DAO 3.6 Object Library when working with a Microsoft Access database.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Opening an ACCDB database or running VBA code that incorrectly references the outdated DAO 3.6 object library.
- Observed behavior
- Microsoft Access triggers a 'Cannot Load DLL' compatibility error because the DAO 3.6 library is incompatible with newer ACCDB file formats.
Determine whether your Microsoft Access database is saved in the older .mdb format or the newer .accdb format, as this dictates which object library reference you need to select in the VBA Editor.
Update VBA References for ACCDB Databases
Resolve the error in modern Access databases by replacing the outdated DAO 3.6 reference with the correct Access database engine Object Library.
The DAO 3.6 Object Library is specifically designed for older .mdb database formats. Using it with a newer .accdb file causes DLL loading failures because the underlying database architectures do not match.
Open your .accdb database in Microsoft Access, then press ALT + F11 on your keyboard to launch the Visual Basic for Applications (VBA) Editor.
From the top menu bar of the VBA Editor, click on 'Tools' and then select 'References' from the drop-down list.
Scroll through the Available References list to find 'Microsoft DAO 3.6 Object Library'. If it says 'MISSING' or is currently checked, uncheck the box next to it.
Locate and check the box for 'Microsoft Office 16.0 Access database engine Object Library' (the exact version number may vary depending on your Office installation). Click 'OK' to save your changes.
Verify Office Architecture for MDB Databases
If you are intentionally using an older .mdb file, ensure your installed Office architecture matches the DAO 3.6 requirements.
Looking for a Free, Lightweight Office Suite?
While Microsoft Access is required for specific database management tasks like fixing DAO 3.6 errors, WPS Office provides a powerful, free alternative for your everyday document, spreadsheet, and presentation needs. Experience seamless compatibility with Word, Excel, and PowerPoint files without the heavy subscription fees.
- 1. Visit the Official Site: Go to the official WPS Office website to access the secure download page.
- 2. Download the Installer: Click the 'Download WPS Office Free' button and run the setup file on your computer.
- 3. Start Creating: Open WPS Office to effortlessly view, edit, and manage your documents, spreadsheets, and presentations.
Frequently Asked Questions
What is the Microsoft DAO 3.6 Object Library?
The Microsoft DAO 3.6 Object Library is a component used in VBA to interact with older Microsoft Access databases, specifically those saved in the legacy .mdb file format.
Why do I get a DLL error when using DAO 3.6 in an ACCDB file?
The newer .accdb database format utilizes a different database engine (ACE instead of JET). Attempting to load the older DAO 3.6 library in a modern ACCDB file causes a compatibility mismatch, leading to the 'Cannot Load DLL' error.
How do I find the VBA References menu in Microsoft Access?
To access the References menu, open your Access database, press ALT + F11 to open the VBA Editor, and click on 'Tools' in the top menu bar, followed by 'References'.
What if the Microsoft Office 16.0 Access database engine Object Library is missing?
If the 16.0 version is not listed in your References menu, look for a similar entry with a different version number, such as 12.0, 14.0, or 15.0. The version available depends on the specific release of Microsoft Office installed on your computer.
