ODBC Administrator utility could not be found (32-bit vs 64-bit)

[Phil Mayne]

Hi,

This is my first foray into using MySQL. I'm trying to migrate a 64-bit Microsoft Access database to MySQL but I'm falling at the first hurdle.

This is my setup:

64-bit Windows 11 Home, version 22H2
64-bit Microsoft Access 2019
64-bit Microsoft Access Runtime (tried version 2010, 2013 and 2016)
64-bit MySQL Community 8.0
64-bit MySQL Connector/ODBC 8.0

If I run odbcad32.exe from Start/Run, Windows launches the 64-bit ODBC Administrator app (from Windows/System32) and I can see the 64-bit ODBC drivers and maintain my DSNs. This proves that Windows, at least, recognises that my set up is 64-bit.

However, if I launch MySQL Workbench Migration Wizard and click on the "Open ODBC Administrator" button, I get an error message that says:

"Open ODBC Administrator. ODBC Administrator utility could not be found"

At the same time the application opens the 32-bit ODBC Administrator (from Windows/SysWOW64), not the 64-bit app. This means I can't import my 64-bit Access databases into the Migration Wizard.

I've found quite a few instances where others are reporting similar behaviour but have not found any advice that fixes my problem. I've searched this forum for the exact error message I'm getting but there are no hits.

I'd be really grateful if someone could help me out with this.

Many thanks.