Gossamer Forum
Home : General : Databases and SQL :

Interfacing MS Access and MySQL?

Quote Reply
Interfacing MS Access and MySQL?
Any opinions or experiences of the best way to do it?

The MySQL database is on a Unix server. As far as users are concerned it is read-only, but I would like to elicit information from the users to update the desktop Windows MS Access database.

For example, user input would be consolidated into a single table in a MySQL database reserved for that purpose, then the Access would make a daily ODBC connection to fetch the table and process it into a more complex desktop database. Traffic would be low, probably no more than 500 records per day.

I know there are several ways to do it, but can anyone recommend a package (commercial or Open) that is known to be robust under Windows?