ODBC - MYSQL to MS Access
I would like to actually link my MYSQL data (tables) to MS Access so I can use the Access data entry features.
I can go through all the steps, except creating the DSN. I got through all of it except when the system requests "more information". I enter the localhost, root as the username, and my password. For the database I enter the name of the MYSQL database I'm attempting to link to. Then 'test'.
Error message says"Connection Failed [MySQL][ODBC 8.0(w) Driver]Access denied for user 'root'@'localhost'(using password: YES):" If I try to create the DSN in the system folders, it says I'm not logged in as an administrator. Not sure how to get more administrator than I am.
I cannot get the ODBC connection between Access and MYSQL.
Any help will be appreciated.
Subject
Views
Written By
Posted
ODBC - MYSQL to MS Access
768
August 23, 2021 05:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.