How to Fix 32-Bit Microsoft Access and MySQL ODBC Driver Compatibility Issues
Question details
The user needs to connect Microsoft Access 2016 to a MySQL database but is encountering a version-mismatch error because they are attempting to use a 64-bit ODBC driver with a 32-bit application.
- Product
- Microsoft Access 2016
- Device & OS
- Windows
- Scenario
- Setting up a database connection from Microsoft Access to MySQL using an ODBC driver.
- Observed behavior
- A version-mismatch error occurs, preventing the connection because the 32-bit Access application cannot interface with the 64-bit MySQL ODBC driver.
Verify whether your installation of Microsoft Access is 32-bit or 64-bit (via File > Account > About Access) and ensure you have administrative privileges to install new ODBC drivers on your Windows PC.
Install and Configure the 32-Bit MySQL ODBC Driver
Match the ODBC driver bitness to your Microsoft Access application by installing the 32-bit MySQL ODBC driver and configuring the connection via the 32-bit ODBC Data Source Administrator.
The most common cause of the version-mismatch error is assuming the driver should match the Windows operating system (64-bit). However, the ODBC driver architecture must always strictly match the bitness of the host application, which in this case is 32-bit Microsoft Access.
Visit the official MySQL website and download the 32-bit version of the MySQL Connector/ODBC.
Open the Windows Start menu, search for 'ODBC Data Sources (32-bit)', and launch the application.
Navigate to the 'User DSN' or 'System DSN' tab, click 'Add', select the 'MySQL ODBC 8.0 Unicode Driver', and click 'Finish'.
Enter your MySQL database credentials, server IP, and database name. Click 'Test' to verify the connection is successful, then click 'OK'.
Open Microsoft Access, go to 'External Data' > 'New Data Source' > 'From Other Sources' > 'ODBC Database', and select the DSN you just created.
Set Up an SSH Tunnel for Secure Database Connections
If your database hosting provider strictly requires tunneled access for security, you must establish an SSH tunnel before setting up the ODBC connection.
Enhance Your Productivity with WPS Office
While Microsoft Access is used for complex relational databases, for your everyday spreadsheet, document, and presentation needs, WPS Office provides an incredibly lightweight, fast, and free alternative. Avoid complex 32-bit/64-bit architecture issues and enjoy a streamlined workflow.
- 1. Download the installer: Visit the official WPS Office website and click the free download button.
- 2. Install the software: Run the downloaded executable file and follow the standard installation prompts.
- 3. Open and edit your files: Launch WPS Office to easily open, edit, and save your existing Microsoft Office files.
Frequently Asked Questions
Why do I get a version-mismatch error when connecting Access to MySQL?
This error occurs when the bitness of the ODBC driver does not match the bitness of Microsoft Access. If you are running 32-bit Access, you must install and use the 32-bit MySQL ODBC driver, regardless of whether your Windows operating system is 64-bit.
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 'About Access'. The first line in the window will display whether your installation is 32-bit or 64-bit.
Can I install both 32-bit and 64-bit ODBC drivers on the same machine?
Yes, Windows allows you to install both 32-bit and 64-bit ODBC drivers simultaneously. You just need to ensure you open the correct ODBC Data Source Administrator (32-bit) when configuring the DSN for a 32-bit application.
What is an SSH tunnel and why might my database require it?
An SSH tunnel creates an encrypted connection between your local computer and the remote server. Database providers often require it to secure data transmission and prevent unauthorized direct access to the MySQL database over the public internet.
