Office Compatibility Issues

Fix Oracle ODBC Connection Errors in Microsoft Access After Installing Microsoft 365

Adam DavisAdam Davis Nov 13, 2026 869 views

Question details

Restore an Oracle database connection used by Microsoft Access after a Microsoft 365 installation.

Fix Oracle ODBC Connection Errors in Microsoft Access After Installing Microsoft 365
Product
Microsoft Access, Microsoft 365, and Oracle ODBC drivers
Device & OS
not provided
Scenario
An Access database uses ODBC to connect to an Oracle server and needs to keep working after Microsoft 365 is installed.
Observed behavior
Previously working Oracle connections now report an ODBC connection failure. A change in Access architecture or an incompatible Oracle driver may be involved.
Before you start

Record the full ODBC error message and the data source name used by the Access database. Have your Oracle connection details available, and check whether the Microsoft 365 installation replaced the previous Access installation.

Solution 1Recommended

Match the Oracle ODBC driver architecture to Microsoft Access

Use this first if Microsoft 365 may have changed Access from 32-bit to 64-bit.

Access must use an Oracle ODBC driver with the same architecture: 32-bit Access requires a 32-bit driver, and 64-bit Access requires a 64-bit driver. The operating system's architecture alone does not determine which driver Access needs.

1
Check the Access architecture

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

2
Check the matching ODBC administrator

On 64-bit Windows, open Start and search for ODBC Data Sources. Open ODBC Data Sources (32-bit) for 32-bit Access or ODBC Data Sources (64-bit) for 64-bit Access. Check the Drivers tab for an Oracle driver.

3
Install a matching Oracle client and driver

If the required driver is missing, download the matching 32-bit or 64-bit Oracle Instant Client Basic and ODBC packages from Oracle. Use compatible package versions and follow Oracle's installation instructions, including the ODBC driver registration step. If software installation is restricted, ask your administrator to perform it.

4
Configure and test the data source

In the matching ODBC Data Source Administrator, open User DSN or System DSN. Select the data source used by Access and click Configure, or click Add to create it with the matching Oracle driver. Enter the Oracle connection details and use Test Connection if available, then close and reopen Access and test the database.

Match the Oracle ODBC driver architecture to Microsoft Access
A 32-bit data source may not be usable by 64-bit Access: If Access changed architecture, recreate or reconfigure its data source with the matching Oracle driver. Do not assume a visible DSN can be used just because its name appears in the administrator.
Free Microsoft Office alternative

Use WPS Office for Documents and Oracle Data Exports

WPS Office is a free, lightweight alternative for everyday document, spreadsheet, and presentation work. Its familiar interface and Microsoft Office format compatibility make migration straightforward for those files. WPS does not repair Access ODBC connections or replace Access databases, but WPS Spreadsheet can work with Oracle data exported to supported spreadsheet formats.

Review Oracle data exported to XLSX or CSV in WPS Spreadsheet.Work with Microsoft Office formats including DOCX, XLSX, and PPTX.Use a familiar interface for everyday editing and analysis.Keep routine Office file work in a lightweight suite while troubleshooting Access separately.
microsoft office alternative - wps office

Frequently Asked Questions

How do I find out whether Access is 32-bit or 64-bit?

In Access, select File > Account > About Access. The product information identifies the installation as 32-bit or 64-bit. Choose the Oracle ODBC driver architecture based on this value, not just your Windows architecture.

Why did the Oracle connection stop working after installing Microsoft 365?

One possible cause is that Access changed from 32-bit to 64-bit while the Oracle ODBC driver remained 32-bit. Check File > Account > About Access first. If the architecture did not change, inspect the DSN and Oracle client configuration and review the complete error message.

Which ODBC Data Source Administrator should I use?

On 64-bit Windows, search Start for ODBC Data Sources and open the version that matches Access. Use the 32-bit administrator for 32-bit Access and the 64-bit administrator for 64-bit Access, then inspect the Drivers and User DSN or System DSN tabs.

What should I do if the ODBC test works but Access still cannot connect?

Open Access and select External Data > Linked Table Manager. Refresh or relink the affected Oracle tables to the working DSN. Also confirm that Access is using the same data source and credentials that passed the ODBC test.

Can WPS Office fix an Access-to-Oracle ODBC connection?

No. WPS Office does not repair Microsoft Access drivers or provide a replacement for Access database applications. After you export Oracle data to XLSX or CSV using a working database tool, you can open the exported file in WPS Spreadsheet for analysis.