469,599 Members | 2,672 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,599 developers. It's quick & easy.

Using MS Access to get data in/out of a MySQL database

I have no experience using MS Access to interface with MySQL.
I have a tiny MySQL database that might need to have Access connect with it
over the internet and grab data/update etc.
Is this practical and what does it take to do it?

My project is not time sensitive but I'd like to see what methods I can use
to do remote queries with my database running on a *nix/Linux server.
Thanks
--
If you wrestle in the mud with a pig.
you both get dirty, and the pig likes it.

-- Dave Dawson
Jul 24 '06 #1
2 3883
You will have to download and install the MySQL ODBC driver onto your
computer. Once this is done, you will need to establish an ODBC
connection (Control Pannel - Admin Tools - Data Sources) with your
database server.

Once this is done, you can use Access the "import" or "link" tables
functions on access to manipulate data on your server using MS Access.

Hope this helps,
Andy
David Dawson wrote:
I have no experience using MS Access to interface with MySQL.
I have a tiny MySQL database that might need to have Access connect with it
over the internet and grab data/update etc.
Is this practical and what does it take to do it?
Jul 25 '06 #2
to*******@yahoo.com wrote:
You will have to download and install the MySQL ODBC driver onto your
computer. Once this is done, you will need to establish an ODBC
connection (Control Pannel - Admin Tools - Data Sources) with your
database server.

Once this is done, you can use Access the "import" or "link" tables
functions on access to manipulate data on your server using MS Access.

Hope this helps,
Andy
I thank you. This will be tried in due course. (by someone else)
--
If you wrestle in the mud with a pig.
you both get dirty, and the pig likes it.

-- Dave Dawson
Jul 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
2 posts views Thread by Jay Moore | last post: by
5 posts views Thread by Phil Powell | last post: by
7 posts views Thread by phillip.s.powell | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.