'%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)
How to Fix Microsoft Access Reserved Error -7745 with MySQL ODBC
Question details
Users encounter a reserved error (-7745) when attempting to link or import MySQL database tables.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Importing or linking MySQL tables after upgrading to the 64-bit version of Microsoft 365.
- Observed behavior
- Microsoft Access displays reserved error -7745 and fails to establish a connection or import the tables due to an incompatible ODBC driver.
Before proceeding, confirm that your Microsoft 365 installation is 64-bit and ensure you have administrative privileges to modify installed programs and ODBC drivers on your computer.
Downgrade to MySQL ODBC 8.0 Driver
Uninstall the incompatible MySQL ODBC 8.1 driver and replace it with version 8.0 to restore database connectivity in 64-bit Microsoft 365.
The reserved error -7745 is caused by a known compatibility issue between 64-bit Microsoft Office and the MySQL ODBC 8.1 Unicode Driver.
Open the Windows Control Panel, navigate to 'Programs and Features', locate the 'MySQL ODBC 8.1 Unicode Driver', and uninstall it.
Navigate to the official MySQL downloads page and download the installer for the MySQL ODBC 8.0 Driver.
Run the downloaded installer and follow the on-screen prompts to complete the setup for version 8.0.
Open the 'ODBC Data Source Administrator (64-bit)' tool in Windows to recreate or refresh your database connection using the newly installed driver.
Relaunch Microsoft Access and try linking or importing your MySQL tables again to verify the error is resolved.
Configure a System DSN
If using a File DSN causes localized permission or pathing issues, creating a System DSN can establish a more stable connection profile.
Looking for a Lightweight Microsoft Office Alternative?
While WPS Office does not feature a direct database application like MS Access, it offers a robust, free, and lightweight suite for your daily document, spreadsheet, and presentation needs, boasting high compatibility with Microsoft Office formats.
- 1. Visit the Official Website: Go to the official WPS Office website on your computer.
- 2. Download the Installer: Click the 'Free Download' button to get the latest version of WPS Office.
- 3. Install and Launch: Run the installer file, follow the prompts, and launch the application to enjoy seamless document editing.
Frequently Asked Questions
Why does error -7745 happen specifically after upgrading to Microsoft 365 64-bit?
The 64-bit version of Microsoft 365 requires a strictly compatible 64-bit ODBC driver to communicate with external databases. The MySQL ODBC 8.1 driver contains a compatibility bug with the 64-bit architecture of Access, triggering this reserved error.
Do I need to downgrade my actual MySQL Server version as well?
No, you only need to downgrade the MySQL ODBC connector (the client driver) installed on your Windows machine to version 8.0. Your main MySQL database server can remain on its current, updated version.
How do I know if I have the 64-bit or 32-bit ODBC driver installed?
You can check this by opening the 'ODBC Data Source Administrator' in Windows. Be sure to specifically open the 64-bit version of the tool (usually named 'ODBC Data Sources (64-bit)') to see the drivers available for 64-bit applications like your upgraded Office suite.
