Fix Microsoft Access ACCDB ODBC and SSMA Connection Errors
Question details
Connect SSMA or Python pyodbc to a Microsoft Access ACCDB database without missing driver, COM class, or data source 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.
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.
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.
In Access, select File > Account > About Access and look for 32-bit or 64-bit in the product information.
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.
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.
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.
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().

Check the ODBC data source and connection settings
Use this when the driver is present but the application reports that a data source name cannot be found.
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.

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.




