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

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.