MS Access and MySQL databases

[shoa]

Hello

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

S.Hoa

[Jeff North]

On Sun, 3 Jul 2005 20:23:04 +1200, in mailing.database.mysql "shoa"
<so*@slingshot.co.nz> wrote:

| Hello
|
| 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...
|

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.
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

[shoa]

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
S.Hoa

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.
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------