Fix Microsoft Access Crashing When Editing Linked MySQL Tables
Question details
Microsoft Access closes unexpectedly when attempting to edit records in MySQL tables that are linked through ODBC.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Navigating from one record to another while editing MySQL tables linked to Microsoft Access via an ODBC connection.
- Observed behavior
- The Microsoft Access application crashes or forcibly closes without warning during record navigation.
Before modifying your system's ODBC drivers, ensure that you have safely closed Microsoft Access and saved any local objects to prevent database corruption.
Downgrade the MySQL ODBC Connector
Certain versions of the MySQL ODBC Connector, specifically version 8.0.27, have known bugs that cause Microsoft Access to crash. Reverting to a stable previous version like 8.0.26 resolves the issue.
The crashes are often triggered by compatibility issues between the data access methods in Microsoft Access and specific updates in the MySQL ODBC driver. Downgrading the driver removes these unstable changes while maintaining your database connection capabilities.
Open the Windows Control Panel, navigate to 'Programs and Features', find your current MySQL ODBC Connector (e.g., version 8.0.27), right-click it, and select 'Uninstall'.
Visit the official MySQL Product Archives webpage and download the installer for MySQL ODBC Connector version 8.0.26.
Run the downloaded installer and follow the on-screen instructions to complete the setup of version 8.0.26.
Open the 'ODBC Data Sources' administrator tool in Windows. Check your configured System or User DSN to ensure it is correctly utilizing the newly installed 8.0.26 driver.
Launch Microsoft Access, open your database, and attempt to edit and navigate through the linked MySQL records to verify that the application no longer closes.

Looking for a Stable, Free Office Suite? Try WPS Office
While WPS Office does not feature a direct database application like Microsoft Access, it is an exceptionally stable and lightweight alternative for your everyday word processing, spreadsheet, and presentation needs. If you are experiencing frequent crashes with Microsoft products, consider migrating your document workflows to WPS Office.
- 1. Download the Installer: Visit the official WPS Office website and click on the free download button to get the setup file.
- 2. Install WPS Office: Run the downloaded executable file and follow the straightforward prompts to install the suite on your computer.
- 3. Open Your Documents: Launch WPS Office and instantly open, edit, and save your existing Word, Excel, and PowerPoint files without formatting loss.

Frequently Asked Questions
Why does Microsoft Access crash specifically when moving between linked records?
Moving between records triggers data fetching and cursor updates over the ODBC connection. If the ODBC driver has a bug in handling these specific memory or network requests, it causes a fatal error that forces Access to close.
How can I check my current MySQL ODBC Connector version?
Open the 'ODBC Data Sources' application in Windows (search for it in the Start menu). Navigate to the 'Drivers' tab, scroll down to find the MySQL ODBC driver, and look at the 'Version' column.
Will downgrading the ODBC driver affect other applications using MySQL?
It might. If you have other software relying on features or security patches introduced in the newer ODBC driver version, downgrading could impact them. It is recommended to test your other database-dependent applications after making the change.




