Has anybody an idea how to synchronize an MS Access-table with a MySQL-table. Replication?
daniel
Has anybody an idea how to synchronize an MS Access-table with a MySQL-table. Replication?
daniel
You can use ODBC linked tables in Access through MyODBC.
You can find MyODBC in the download section of http://www.mysql.com
Peter
Thanks PAV for your help. I already use MyODBC to edit MySQL tables with MS Access. But thats not what I mean by replication or synchronization. I want to have a local copy of an MySQL table which I can edit offline. From time to time I want to go online and synchronize this two tables. That means:
1) New or updatet local entries should be copied to the MySQL table, 2) New or updatet entries in the MySQL talbe should be copied to the local table 3) If an entrie is updatet in both tables, Access should ask me which one is the right one. This is possible with an MS SQL-Server. But is it also possible with MySQL?
OK, I understand.
As far as I know there is no such function in MySQL.
I think you don't get around to do some programming in MS Access. In this you check for changes in the local MySQL db and in the MySQL db on the server, move these changes from both db's to an temp db and update both db's again with these changes.
But what if a record is changed both on the local and server side, which one do you take, I wonder?
Peter