mysql and access

[makaroner]

I need to continously copy any new entries from an MS Access db to a MySQL db... basically I need to mirror/replicate the Access db. )

The MySQL db is version 3.23 and is on a machine running FreeBSD. Access 2000 is on a machine w/ nt4 and I'm using using Easysoft's ODBC-ODBC bridge between the databases.

Are there any clever built-in functions that I could use to replicate the data? Any other tips or hints are welcome. Though I do not need to be told not to use Access, it's not really by choice. )

 

[Broccoli2]

Three options:

1. Convert your tables in Access to be linked tables direct into the MySQL database (ie effectively no native storage in Access you just use Access as a 'front end')

2. (More tricky) Have native tables and linked tables in parallel in your Access database, then periodically run a macro which deletes all the records from the linked tables and inserts the records from the native tables.

3. (More tricky still) Presumably you're using forms to update your tables in Access. You could delve into the VB of every action which alters the tables and run duplicate code to perform the same changes on the MySQL database. However, this sounds like a nightmare.

-Rob