Others

Fix Microsoft Access ACCDB ODBC and SSMA Connection Errors

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Connect SSMA or Python pyodbc to a Microsoft Access ACCDB database without missing driver, COM class, or data source errors.

Fix Microsoft Access ACCDB ODBC and SSMA Connection Errors
Product
Microsoft Access, SQL Server Migration Assistant for Access, and Python pyodbc
Device & OS
not provided
Scenario
A user is connecting a third-party tool to an Access ACCDB file.
Observed behavior
SSMA or pyodbc reports a missing Access COM class, ODBC driver, or data source.
Before you start

Identify which application produces the error and locate the ACCDB file. If you use a named ODBC data source, note its DSN; the architecture of the application and ACE driver must match.

Solution 1Recommended

Match the application and Access Database Engine architectures

Use this approach when the ACE ODBC driver or Access COM class is missing or the application cannot load it.

A 32-bit application needs 32-bit ACE components, while a 64-bit application needs 64-bit components. An existing Access installation does not necessarily make the required driver available to third-party tools.

1
Check Access architecture

In Access, select File > Account > About Access and look for 32-bit or 64-bit in the product information.

2
Check the connecting tool

For Python, run python -c "import struct; print(struct.calcsize('P') * 8)" in the same environment that runs pyodbc. For SSMA, check the installed edition and launch the version matching the available Access components.

3
Install matching ACE components

Obtain the appropriate Microsoft Access Database Engine or Access Runtime from Microsoft and install the edition matching the connecting application. If the installer reports a conflict with an existing Office installation, follow Microsoft's installation guidance rather than forcing a mixed-bitness installation.

4
Verify the ODBC driver

Open ODBC Data Source Administrator for the application's architecture and select the Drivers tab. Look for a Microsoft Access driver that lists *.accdb. From Python, you can also run python -c "import pyodbc; print(pyodbc.drivers())" in the same environment.

5
Retry the connection

Restart SSMA or the Python process and connect to the ACCDB file again. In a pyodbc connection string, use the exact Access driver name shown by pyodbc.drivers().

Match the application and Access Database Engine architectures
Check the exact missing component: A registered ODBC driver does not by itself confirm that every COM component SSMA needs is available. If a COM class error remains, check Microsoft's SSMA and Access component requirements for the installed versions.
Free Microsoft Office alternative

Work with exported Access data in WPS Spreadsheets

WPS Office is a free, lightweight, easy-to-use Microsoft Office alternative with a familiar interface. Open exported spreadsheet data and compatible Office files for a smooth transition. WPS does not repair ACE drivers or replace Access for ACCDB database connections.

Review and edit spreadsheet data exported from AccessOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

How can I see which Access ODBC drivers Python can use?

Run python -c "import pyodbc; print(pyodbc.drivers())" in the same Python environment as your application. The result lists drivers visible to that Python architecture.

Why can't a 64-bit Python process find my 32-bit Access driver?

A 64-bit process cannot load a 32-bit ODBC driver. Use a 64-bit ACE driver with 64-bit Python, or use 32-bit Python with a 32-bit ACE driver, subject to your Office installation's compatibility requirements.

Where do I create a DSN for a 32-bit application?

On 64-bit Windows, open %windir%\SysWOW64\odbcad32.exe, select User DSN or System DSN, and choose Add. Select the Access driver and configure the ACCDB file.

Can WPS Office fix an SSMA Access COM class error?

No. The error concerns Microsoft Access components and SSMA. Check their architecture and Microsoft's component requirements. WPS Spreadsheets can work with exported spreadsheet data but does not repair the Access connection.