Results 1 to 2 of 2

ODBC Connector for MySQL Access Denied

  1. #1
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    645

    Exclamation ODBC Connector for MySQL Access Denied

    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.

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    645
    I have not been able to fix this issue, however access can use the connector for the database needs... Odd

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Connection lost from mysql remote odbc with MS Access
    By zeeshanaslamdurrani in forum Code Repository
    Replies: 1
    Last Post: 02-21-2016, 06:13 AM
  2. Replies: 3
    Last Post: 04-24-2015, 04:09 AM
  3. Replies: 1
    Last Post: 11-15-2014, 11:41 AM
  4. How to make a persistent ODBC connection MySQL to Access
    By Yann63 in forum Import/Export Data
    Replies: 4
    Last Post: 01-24-2014, 08:44 AM
  5. Access connector to Android
    By mibl in forum Access
    Replies: 2
    Last Post: 11-15-2011, 01:31 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums