|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Has anybody an idea how to synchronize an MS Access-table with a MySQL-table. Replication?
daniel |
|
#2
|
|||
|
|||
|
You can use ODBC linked tables in Access through MyODBC.
You can find MyODBC in the download section of http://www.mysql.com Peter |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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 |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Replication MS Access -> MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|