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?
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?