Fix the DAO 3.6 Object Library DLL Loading Error in Excel
Question details
Resolve an Excel VBA compile error caused by an unavailable Microsoft DAO 3.6 Object Library reference.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel VBA macro uses DAO.Database and DAO.QueryDef to work with a database.
- Observed behavior
- The macro fails to compile because the DAO 3.6 Object Library cannot load dao360.dll.
Open the workbook in Excel and identify its database file and connection method. In Excel, check File > Account > About Excel to see whether Office is 32-bit or 64-bit.
Replace the DAO 3.6 reference with the Access Database Engine library
Use this approach when the DAO 3.6 reference is missing or cannot load in a newer version of Office.
Open the workbook in Excel and press Alt+F11 to open the Visual Basic Editor.
Select Tools > References. Clear the checkbox for Microsoft DAO 3.6 Object Library, especially if it is marked MISSING.
In the same References dialog, select Microsoft Office 16.0 Access Database Engine Object Library, or the available version of the Access Database Engine Object Library, and click OK.
Select Debug > Compile VBAProject, then run the macro against the intended database and check its results.

Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move everyday workbook editing to WPS. It does not repair Excel's DAO reference, and VBA macro compatibility can vary.

Frequently Asked Questions
Where can I find the missing DAO reference in Excel?
Press Alt+F11 in Excel, then select Tools > References in the VBA editor. Look for Microsoft DAO 3.6 Object Library or an entry marked MISSING.
What if the Access Database Engine library is not listed?
Check Microsoft's installation guidance for the Access Database Engine or Access Runtime, including compatibility with your Office version and 32-bit or 64-bit architecture. Reopen Excel and check Tools > References again after installation.
Will registering dao360.dll fix the compile error?
Not necessarily. DAO 3.6 is an older library, and registering its DLL may not resolve compatibility issues in newer Office versions. Try replacing its reference with the available Access Database Engine object library.
Does changing the reference guarantee that my macro will run?
No. After selecting the replacement under Tools > References, use Debug > Compile VBAProject and test the macro. Database connection details or code may also need changes.




