Office Apps Crashing

Fix Microsoft Access Crashing When Editing Linked MySQL Tables

Natalie TaylorNatalie Taylor Nov 3, 2026 869 views

Question details

Microsoft Access closes unexpectedly when attempting to edit records in MySQL tables that are linked through ODBC.

How to Fix Microsoft Access Crashing When Editing Linked MySQL Tables
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 you start

Before modifying your system's ODBC drivers, ensure that you have safely closed Microsoft Access and saved any local objects to prevent database corruption.

Solution 1Recommended

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.

1
Uninstall the Current Connector

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'.

2
Download an Older Version

Visit the official MySQL Product Archives webpage and download the installer for MySQL ODBC Connector version 8.0.26.

3
Install the Older Connector

Run the downloaded installer and follow the on-screen instructions to complete the setup of version 8.0.26.

4
Reconfigure Your ODBC Data Source

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.

5
Test the Linked Tables

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.

Downgrade the MySQL ODBC Connector
Match Architecture Versions: Make sure you download and install the 32-bit or 64-bit ODBC driver that matches the architecture of your Microsoft Office installation, not your Windows operating system.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and click on the free download button to get the setup file.
  2. 2. Install WPS Office: Run the downloaded executable file and follow the straightforward prompts to install the suite on your computer.
  3. 3. Open Your Documents: Launch WPS Office and instantly open, edit, and save your existing Word, Excel, and PowerPoint files without formatting loss.
Highly compatible with Microsoft Office file formats (.docx, .xlsx, .pptx).Completely free to use with a familiar, easy-to-navigate user interface.Lightweight software that runs smoothly without taxing system memory.
microsoft office alternative - wps office

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.