Microsoft 365 Error Codes

Fix DAO.DBEngine.120 Errors with Office 2019 Click-to-Run

Adam DavisAdam Davis Nov 13, 2026 869 views

Question details

An external application needs to create a DAO.DBEngine.120 object to work with ACCDB files alongside Office 2019 Click-to-Run.

Fix DAO.DBEngine.120 Errors with Office 2019 Click-to-Run
Product
Microsoft Access 2019 and Microsoft Access Database Engine
Device & OS
not provided
Scenario
An external application uses CreateObject("DAO.DBEngine.120") to access an ACCDB database.
Observed behavior
Creating the DAO.DBEngine.120 object fails. In a reported attempt, installing a redistributable also prevented Access from starting.
Before you start

Check whether the external application is 32-bit or 64-bit, and check Office's architecture in Access under File > Account > About Access if Access opens. Note any exact error message and existing Access Database Engine installations before making changes.

Solution 1Recommended

Install a compatible Access Database Engine redistributable

Use this approach when an external application cannot see the DAO components installed with Office Click-to-Run.

Click-to-Run isolation can prevent an external application from accessing Office's database components. The database engine must match the external application's architecture and be compatible with the installed Office environment.

Installing an engine does not guarantee that the exact DAO.DBEngine.120 ProgID will be registered. Confirm that the version you select supports your application and Office configuration.

1
Check installed components

Open Windows Settings > Apps and look for Microsoft Access Database Engine redistributables. Compare their architectures with the external application and Office.

2
Review Microsoft's requirements

Find the Access Database Engine redistributable on Microsoft's official download or support site. Review its architecture and Office compatibility requirements before downloading it.

3
Install the compatible package

Close Access and the external application, then run the installer for the compatible engine. Do not bypass an installer compatibility warning without first resolving the conflict.

4
Retest the application

Start the external application and retry CreateObject("DAO.DBEngine.120") against the ACCDB file. Also open Access from the Start menu to check that it still launches.

Install a compatible Access Database Engine redistributable
If the ProgID still fails: Record the exact error and check whether DAO.DBEngine.120 is registered for the application's architecture. Consult the application vendor or Microsoft documentation before changing the ProgID or registry.
Free Microsoft Office alternative

Use WPS Office for everyday Office documents

WPS Office is a free, lightweight alternative with a familiar interface for editing documents, spreadsheets, and presentations. Its Microsoft Office format support helps make the move seamless. It does not fix DAO registration or replace Access for ACCDB database applications.

Edit Word, Excel, and PowerPoint files, including DOCX, XLSX, and PPTX formatsWork in a familiar interface that makes migration easierUse a lightweight office suite for everyday document tasksKeep document work separate from Access database troubleshooting
microsoft office alternative - wps office

Frequently Asked Questions

Why can't my application create DAO.DBEngine.120 when Office 2019 is installed?

Office 2019 Click-to-Run can isolate database components from external applications. A compatible Access Database Engine redistributable may be needed, but the exact error, application architecture, and ProgID registration should also be checked.

Should the database engine match Office or the external application?

The engine must match the external application's 32-bit or 64-bit architecture and also be compatible with the installed Office environment. Review Microsoft's installation requirements before choosing a package.

What should I do if Access no longer opens after installation?

In Windows Settings > Apps, uninstall the recently added Access Database Engine redistributable and test Access again. If it still fails, select Office 2019, choose Modify, and run a repair.

Does installing a redistributable always register DAO.DBEngine.120?

No. Registration depends on the engine version and installation. If CreateObject still fails, check the exact error and whether the ProgID is registered for the application's architecture.

Can WPS Office fix the DAO error or run my ACCDB application?

No. WPS Office is an alternative for documents, spreadsheets, and presentations; it does not fix Microsoft Access DAO registration or replace the Access database engine.