VBA & Macro Problems

Fix the DAO 3.6 Object Library DLL Loading Error in Excel

Rana GarciaRana Garcia Nov 22, 2026 869 views

Question details

Resolve an Excel VBA compile error caused by an unavailable Microsoft DAO 3.6 Object Library reference.

Fix the DAO 3.6 Object Library DLL Loading Error in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA editor

Open the workbook in Excel and press Alt+F11 to open the Visual Basic Editor.

2
Remove the unavailable reference

Select Tools > References. Clear the checkbox for Microsoft DAO 3.6 Object Library, especially if it is marked MISSING.

3
Select the replacement library

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.

4
Compile and test the macro

Select Debug > Compile VBAProject, then run the macro against the intended database and check its results.

Replace the DAO 3.6 reference with the Access Database Engine library
Check database compatibility: The replacement library may require changes to database connections or code. If it is not listed, check Microsoft's Access Database Engine or Access Runtime installation guidance and match the installed Office architecture. Registering dao360.dll alone may not resolve the issue.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsMove everyday workbook editing to a lightweight office suiteUse free spreadsheet tools for common tasks
microsoft office alternative - wps office

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.