Here's what I found:
http://forums.mysql.com/read.php?37,10223,10223#msg-10223
Solution appears to be use older version of MyODBC (3.51.9) and have no password.
Note: DBTools Manager Professional would not let me create a user without a password, but MySQL Control Center would.
-
Sen
I'm having the exact same problem. Just getting started with Access and MySQL. I'm trying to convert old Access backend to MySQL and still use Access as front end. Doing just 1 table for now, link it and it works. Shut down Access and reload, then I get the Failed ODBC error like you said...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.