MS Access and MySQL databases

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have an Access database that is used for a station computer. Now I want to
update this database for a small network for about 4 computers (to share
this database). I know that I can link an Access databse to a MySQL server.
My question is:

It is possible to use one of those for computers as a MySQL server then 4
computers will use 4 copies of this Access application to connect to the
MySQL server to share data.
If it is possible, please help me how to do that...

Thanks for any help


Re: MS Access and MySQL databases

On Sun, 3 Jul 2005 20:23:04 +1200, in mailing.database.mysql "shoa"

Quoted text here. Click to load it

Download the mysql odbc driver and install.
Set up a File dsn for the mysql database.
Open the access database and link the mysql tables.

You might want to have a look at the datatypes for each database.
Access doesn't handle some of mysql's datatypes too well i.e. bigint.
---------------------------------------------------------------  : Remove your pants to reply

Re: MS Access and MySQL databases

Thank you very much...

Now I can access MySQL from MS Access for a Server computer that has both MS
Access and MySQL on it. However, I do not know how to setup MS Access
clients for other computers to link with this MySQL server (do I have to set
IP...). Please help

Many thanks

Quoted text here. Click to load it

Site Timeline