MySQL Bugs: #116316: Migrating MS Access tables to MySql using Workbench

Bug #116316	Migrating MS Access tables to MySql using Workbench
Submitted:	9 Oct 2024 0:57	Modified:	9 Oct 2024 14:16
Reporter:	Sheri Trager	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Microsoft Access, Migration MySQL Workbench, Migration; Acces DB; Import

Description:
I had just installed MySQL community with Workbench.  I set up the ODBC connections and was attempting to migrate my MS Access tables to MySql.  I was using the WorkBench Migration Wizard.  It was the Reverse Engineer Source that failed.

How to repeat:

Used workbench migration wizard.

Followed instructions on page https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html

Each connection test succeeded.  
Received error on step... Reverse Engineer Source

Hi Mr. Trager,

Thank you for your bug report.

First of all, we see that you are using 32-big Windows NT.

How have you been able to install 64-bit MySQL server with ODBC and 64-bit Workbench on an NT ???

Next ..... and FAR more important, if you read the log, you will find out that the problem is in MS Access ODBC driver, made and maintained by Microsoft Inc.

Hence, you should report it to Microsoft as they are the ones making ODBC driver for MS Access.

Not a bug.