Connect access form to MYSQL

MAS
MAS used Ask the Experts™
on
I would like to connect my MYSQL to access form.
Is there any article to connect access form to MYSQL.
I tried to add datasource but I cant see MYSQL listed
test.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst
Commented:
If you want to use MySQL in a Access database the steps to follow are described here: https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html
MySQL ODBC driver can be found here https://dev.mysql.com/downloads/connector/odbc/ and must be installed on the same computer with the Access database.

You should be able to "... use a MySQL database with Microsoft Access using Connector/ODBC. The MySQL database can be used as an import source, an export source, or as a linked table for direct use within an Access application, so you can use Access as the front-end interface to a MySQL database." as described here: https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access.html
MASEE Solution Guide - Technical Dept Head
Most Valuable Expert 2017

Author

Commented:
HI lcohan,
Thanks for your reply.
I connected to the database now but I cant see any tables/data.
What could be the issue?
test.JPG
Distinguished Expert 2017
Commented:
depending on what you entered when connectin, did you use username, password and database?
Did you setup a user that has requisite rights (grant  on the mysql)
tested the ODBC connection?
MASEE Solution Guide - Technical Dept Head
Most Valuable Expert 2017

Author

Commented:
I can see only 2 databases listed.
When I type the database I want to connect I get this error
test.JPG
MASEE Solution Guide - Technical Dept Head
Most Valuable Expert 2017

Author

Commented:
Thanks to both, created a new user and gave permission.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial