This is possible but the first thing you need to arrange is how your user can access your
machine at all from the other state. That is matter of networking, firewalls etc. and
nothing to do with MySQL.
Once you are sure you have network access arranged you will need to tell your user the IP
address/URL of your machine, the name of the database, the user name to use and the
password. Armed with that he should be able to set up an ODBC data source in
administrative tools in control panel. With that set up he can create links to the
required tables from inside Access by choosing the ODBC data source.
From: rajkumar arya [mailto:rajkumar_arya2000@stripped]
Sent: Monday, 30 January 2012 4:44 PM
Subject: How to connect Mysql Install on windows by ODBC from the different Loaction
I am new to mysql, I have install mysql 5.5.16 on window 7. My one user is sitting in
diffrent State and i want to give him access to mysql database using odbc, so that he/she
can update/view the relevant infromation in the databast by using ms acces as front
end. Please suggest how it is possible.