Question How to connect Ms Access (FE) to MySQL (BE)

[budzprog]

hello, anyone can teach me how to connect MS ACCESS (front end) to MySQL database (back end) from two different computers... I mean the Database which is MySQL is located at comp A then my MS ACCESS is located in comp B.
Thank You

 

[John.Woody]

Google up the mysql odbc connector, they give instructions to install setting the tcpip server to your server computer where the data is, then in access Get External Data - Link Tables and in files of type select odbc databases, select your connection, or create a new one here and then you can select your tables in the usual way.

 

[budzprog]

thank you. i will try this solution...