'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Access Cannot Open Tables Through a 32-Bit ODBC Connection
Question details
The user is unable to open or relink tables in a newer Microsoft Access installation despite successfully testing a 32-bit ODBC connection to a remote database.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to connect to a remote database using an existing 32-bit ODBC connection after updating or reinstalling Microsoft Access.
- Observed behavior
- The ODBC connection tests successfully in the ODBC Data Source Administrator, but Microsoft Access throws an error and fails to open or relink the linked tables.
Verify whether your current installation of Microsoft Access is 32-bit or 64-bit, as the ODBC driver architecture must exactly match the Access version you are using.
Install and Configure a 64-Bit ODBC Driver
If you are using 64-bit Access, you must use a 64-bit ODBC driver and recreate your Data Source Name (DSN) using the 64-bit administrator.
Modern installations of Microsoft Office typically default to the 64-bit architecture. A 64-bit application cannot communicate with a 32-bit ODBC driver, even if the 32-bit connection tests successfully on its own.
Visit your database provider's official website (e.g., MySQL, SQL Server) and download the 64-bit version of their ODBC Connector.
Run the downloaded installer to add the 64-bit ODBC driver to your Windows system.
Search for 'ODBC Data Sources (64-bit)' in the Windows Start menu and open the application.
Navigate to the System DSN or User DSN tab, click 'Add', select the newly installed 64-bit driver, and enter your remote database connection details.
Open Microsoft Access, navigate to the 'External Data' tab, select 'Linked Table Manager', and refresh or relink your tables using the new 64-bit DSN.
Reinstall Microsoft Office in 32-Bit
If your remote database strictly requires 32-bit drivers and no 64-bit equivalent is available, you will need to revert your Office installation to 32-bit.
Looking for a Lightweight Office Suite?
While WPS Office does not include a database management tool like Access, it is a fantastic, free, and lightweight alternative for your daily document, spreadsheet, and presentation needs. Enjoy high compatibility with Microsoft Office files without the heavy installation.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the lightweight installer to quickly set up the productivity suite on your computer.
- 3. Open Your Files: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint files with perfect formatting.
Frequently Asked Questions
Why does my 32-bit ODBC connection test successfully but fail in Access?
The Windows ODBC Data Source Administrator (32-bit) can successfully test a 32-bit connection independently. However, if your Microsoft Access installation is 64-bit, it cannot communicate with a 32-bit DSN, resulting in a failure when attempting to open or relink tables.
How do I check if my Microsoft Access is 32-bit or 64-bit?
Open Microsoft Access, click on the 'File' menu, select 'Account', and click the 'About Access' button. The resulting dialog box will display the full version number along with whether it is a 32-bit or 64-bit installation.
Can I run both 32-bit and 64-bit Office on the same computer?
No, Microsoft does not support installing both 32-bit and 64-bit versions of Office products on the same computer. You must choose one architecture for your entire Office suite based on your plugin and database requirements.
