Linking MS Access 2000 to MySQL server

[shamsm]

Hi

I would like to link an Access 2000 DB to a MySQL Server which is connected to UltraDev, I know how to export tables but I need to know if the two can be linked in any way so the data is updated simultaneously, I need this as the site I am creating requires regular update.

Regards

 

[sleipnir214]

Install MyODBC on your system. It is available from

http://www.mysql.com.

Set up a Machine datasource DSN to the MySQL server using the MyODBC driver in your control panel.

In Access, go to File/Get External Data/Link Tables. In the link dialog box, set your "Files of type" drop-down box to "ODBC databases". In the next dialog box, select the DSN you created. From there, it's pretty straightforward.

Keep in mind, you will need a userid that can access the tables from your IP address. ______________________________________________________________________
Never forget that we are
made of the stuff of stars

 

[shamsm]

Thank you for that, I managed to link my database.

Regards