Solved Which MYSQL ODBC Connector works well for MySQL version 8.0.40 (FE MS Access)

[nectorch]

I have been having problems with MySQL version 8.0.40 , I'm currently using the listed MYSQL connector ODBC with MS Access as FE:

(1) 9.1 ODBC with 64 BIT is now failing
Now I have redo all the deployment all over again

Any idea which odbc version works well with MySQL version 8.0.40 with MS Access 64 BIT Or 32 BIT?

 

[cheekybuddha]

I would use the latest version 8 MyODBC.

 

[nectorch]

But version is only available for 32 BIT not 64 BIT MS Access.

And yes version 8.0.0 is working okay for 32 BIT that is what I'm using, what 64 BIT?

 

[cheekybuddha]

OK, I don't know what is wrong with the MyODBC download page,

BUT ...

1. Choose the 'Archives' tab instead of 'General Availability (GA) Releases'
2. Select Product Version: 8.0.40
3. Operating System: Microsoft Windows

Then the 64bit installers appear for download.

 

[cheekybuddha]

Also, (I think you know this, but just in case ...) make sure the driver bitness matches Access bitness, not Windows bitness.

So 64bit Windows and 32bit Access, use 32bit MyODBC.
64bit Windows and 64bit Access, use 64bit MyODBC.

 

[cheekybuddha]

See also the penultimate entry in this MySQL bug report [18 Dec 11:13] about having to update the Visual C++ Redistributable package to get MyODBC 9 to work.

Maybe that could help you?