Fix Oracle ODBC Connection Errors in Microsoft Access After Installing Microsoft 365
Question details
Restore an Oracle database connection used by Microsoft Access after a Microsoft 365 installation.

- 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.
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.
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.
Open Microsoft Access, select File > Account > About Access, and look for the 32-bit or 64-bit designation in the product information.
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.
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.
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.

Verify the Oracle data source and refresh Access linked tables
Use this when Access and the Oracle driver already match, or the connection still fails after installing the correct driver.
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.

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.




