Link to home
Start Free TrialLog in
Avatar of M A
M AFlag for United States of America

asked on

Connect access form to MYSQL

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
User generated image
SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of M A

ASKER

HI lcohan,
Thanks for your reply.
I connected to the database now but I cant see any tables/data.
What could be the issue?
User generated image
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of M A

ASKER

I can see only 2 databases listed.
When I type the database I want to connect I get this error
User generated image
Avatar of M A

ASKER

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