By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,400 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

How do I Link to a MySQL Workbench Back-End Table

P: 44
Hi i am attempting to use a MySQL backend with Access rather than a Jet DB backend. Does anyone know of any good tutorials on once i have made a DB/scheme in MySQL workbench how to have this linked to a table in MS Access
Thanks for any replys
May 5 '12 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,186
You want to link a schema in MySQL to a Table in Access? I'm not sure that makes sense.
May 5 '12 #2

P: 44
Sorry my mistake, i meant a table. Ive not dealt with MySQL or Workbench before so its a bit of a learning curve for me at the moment. The issue i have is for eg if i want to import external data and link that data to a table in access from lets say a excel file it is quite easy point to the file and its done. Where as when i try but use a sql connection instead i navigate to the folder where i have created the database in MySQL and i have a .mwb file and a mwb.bak file. neither if which will link to a table. Hope that explains myself better
May 6 '12 #3

NeoPa
Expert Mod 15k+
P: 31,186
Ah. So you simply want to link to a MySQL table from an Access database.

I haven't used MySQL myself, but when I linked to SQL Server I found that I had to select the ODBC () option to do it. Then, assuming you have the relevant drivers installed on your system, you will be in a position to select the one for MySQL and import your tables from your MySQL server.

I hope that helps.
May 6 '12 #4

mshmyob
Expert 100+
P: 903
Here are my step by step instructions for linking MySQL to Access. See post #6
http://bytes.com/topic/access/answer...-access-2007-a

cheers,
May 7 '12 #5

NeoPa
Expert Mod 15k+
P: 31,186
Handy. I've saved a link to that Rob :-)
May 8 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.