I am trying to have an Access Database use MySQL for the backend.
When I try to setup the MySQL 32Bit ODBC Connector I get an error saying
Connection Failed:Hy000 MySql ODBC Driver Access denied for user invDB@Alex-laptop.cyclomedical.com with password Yes
I have setup the invDB user in MySQL workbench on the server to allow hosts at % and flushed the priv's.
Firewall is not running on my machine, firewall on server appears to be set to allow throughput. I am able to connect and configure data via the MySQL WorkBench remotely to the server.
What can I do to fix this? Google has an almost endless path on this subject.