Fix Access Runtime Errors in Microsoft 365 by Comparing ODBC Drivers
Question details
Identify why an application fails in Microsoft 365 Access Runtime but works in Access Runtime 2016.

- Product
- Microsoft 365 Access Runtime and Access Runtime 2016
- Device & OS
- not provided
- Scenario
- An application is run with two versions of Access Runtime and may depend on ODBC drivers or other database components.
- Observed behavior
- The application produces an error in Microsoft 365 Access Runtime but runs correctly in Access Runtime 2016.
Record the exact error message and identify the database connection that triggers it. If possible, inspect both runtime environments so you can compare their drivers, architecture, and connection settings.
Compare ODBC drivers and runtime architecture
Use this comparison to find driver or bitness differences that may explain the error.
On each Windows installation, open Task Manager and check the Access process architecture in the Details view. Record whether each runtime is 32-bit or 64-bit.
Open the ODBC Data Source Administrator matching the runtime architecture: run %windir%\SysWOW64\odbcad32.exe for 32-bit or %windir%\System32\odbcad32.exe for 64-bit. On the Drivers tab, compare driver names and versions in both environments.
In the matching ODBC Data Source Administrator, compare the User DSN and System DSN settings used by the application. Also inspect its connection string or configuration file for the driver name, server, database, and authentication settings.
Where compatible, install or select the same ODBC driver and architecture used by the working environment, update the application's DSN or connection string if needed, and run the application again.

Review Access Database Engine and application dependencies
Use this check if matching the ODBC driver does not resolve the error.
Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents and moving between suites. It does not fix Access Runtime errors or run Access database applications.

Frequently Asked Questions
Why does the application work in Access Runtime 2016 but fail in Microsoft 365 Access Runtime?
The environments may use different ODBC drivers, runtime architectures, connection strings, or database components. Compare these settings and use the exact error message to narrow down the cause.
How do I check which ODBC drivers are installed?
On Windows, open the ODBC Data Source Administrator for the application's architecture and select the Drivers tab. Run %windir%\SysWOW64\odbcad32.exe for 32-bit drivers or %windir%\System32\odbcad32.exe for 64-bit drivers.
Does my ODBC driver need to match Access Runtime bitness?
Yes. A 32-bit Access application needs a 32-bit ODBC driver, and a 64-bit application needs a 64-bit driver. Check the driver in the corresponding ODBC Data Source Administrator.
Can WPS Office run my Access Runtime application?
No. WPS Office does not run Access database applications or replace Access Runtime. It can open common Office files and spreadsheet exports, but the Access Runtime issue must be resolved in the Microsoft environment.




