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

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

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?

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

torpecool@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