Others

Fix SQL Server Migration Assistant Error 80040154 for Access

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

Resolve error 80040154 when using SQL Server Migration Assistant to migrate an Access database.

Fix SQL Server Migration Assistant Error 80040154 for Access
Product
SQL Server Migration Assistant for Access
Device & OS
not provided
Scenario
The user is migrating a Microsoft Access database to SQL Server with SQL Server Migration Assistant.
Observed behavior
SSMA reports REGDB_E_CLASSNOTREG, indicating that a required Access Database Engine or DAO COM component may be missing, unregistered, or incompatible with SSMA's bitness.
Before you start

Check the prerequisites for your version of SQL Server Migration Assistant for Access and identify the required Access Database Engine components. Note whether SSMA and the installed Access or Office components are 32-bit or 64-bit.

Solution 1Recommended

Install a compatible Access Database Engine

Use this approach when the required database engine is missing or its bitness does not match SSMA.

1
Check Access bitness

In Microsoft Access, open File > Account > About Access and look for 32-bit or 64-bit in the version information.

2
Check installed components

Open Windows Settings > Apps > Installed apps and look for SQL Server Migration Assistant for Access and Microsoft Access Database Engine. Check their installation details or the installer used to determine their bitness.

3
Install the required engine

Consult Microsoft's SSMA for Access prerequisites, then download and install the Access Database Engine version required for your SSMA release. Use a 32-bit or 64-bit engine compatible with SSMA and your installed Office components.

4
Restart and retry

Restart the computer, open SQL Server Migration Assistant for Access, and run the migration again.

Install a compatible Access Database Engine
Office installation conflicts: If the engine installer reports a conflict with an existing Office installation, follow Microsoft's installation guidance rather than forcing incompatible 32-bit and 64-bit components together.
Free Microsoft Office alternative

Use WPS Office for everyday Office documents

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easier to move everyday document work. It does not replace SSMA or fix Access Database Engine errors.

Open and edit Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTX.Work with exported spreadsheet data in a familiar interface.Use a free, lightweight suite for everyday document tasks.
microsoft office alternative - wps office

Frequently Asked Questions

What does error 80040154 mean in SSMA for Access?

It is a class-not-registered error. A required Access Database Engine or DAO COM component may be missing, unregistered, or incompatible with the bitness of SSMA.

How do I check whether Microsoft Access is 32-bit or 64-bit?

In Access, select File > Account > About Access. The version information identifies the installation as 32-bit or 64-bit.

Why do I still get the error after switching to 64-bit?

Matching bitness alone does not ensure that the required engine is installed and registered. Check the SSMA prerequisites, then use Settings > Apps > Installed apps to repair or reinstall the compatible Access Database Engine.

Can WPS Office fix this SSMA migration error?

No. The error concerns Microsoft SSMA and Access Database Engine components. WPS Office can work with common Office documents and spreadsheets, but it does not replace the Access-to-SQL Server migration tools.