Connecting to MySQL table

[smig]

How do I connect to MySQL table ?
Never worked with MySQL

Is it possible to temporary connect to the table or do I need to create a permanent connection?

 

[theDBguy]

Hi. Do you have the proper ODBC driver installed on your machine? Did you try using the External Data tab and try to link to the MySQL database using ODBC?

 

[smig]

Hi. Do you have the proper ODBC driver installed on your machine? Did you try using the External Data tab and try to link to the MySQL database using ODBC?

Please talk to me in a language I can I understand

What ODBC driver?
How do I link to the MySQL db ?

 

[theDBguy]

Please talk to me in a language I can I understand

What ODBC driver?
How do I link to the MySQL db ?

Hi. It would take me a while to explain it step-by-step. I think this website might do a better job at it. I hope it helps...

MySQL :: MySQL Connector/ODBC Developer Guide :: 6.4.3 Using Microsoft Access as a Front-end to MySQL

dev.mysql.com

 

[access2010]

Hi. It would take me a while to explain it step-by-step. I think this website might do a better job at it. I hope it helps...

MySQL :: MySQL Connector/ODBC Developer Guide :: 6.4.3 Using Microsoft Access as a Front-end to MySQL

dev.mysql.com

Hello, theDBguy
We are working on creating a MsAccess link to MySql, do you have any other research suggestions to look at?
I/we always appreciate your assistance.
Nicole

 

[Pat Hartman]

That is a very broad topic. We can help you better if you have specific questions.

If you have never converted any Access application to any RDBMS, you are probably going to be disappointed with the results of a strait conversion if you haven't used good client/server techniques. But try it and we'll see how we can help.

I've never used MySQL but they might have a way of directly importing the Jet/ACE tables and creating the MySQL database for you. Looks like this might be it -- How to convert Access to MySQL? | DBConvert
Another option:
Access To MySQL (bullzip.com)

There are other tools also. My personal preference is to actually PAY for tools I use. When tools are "free", YOU are the product and I don't trust them with production data. Who knows where it gets sent?