Synchronizing databases

[dwidmer]

Hi

I've just set up a new website using php and mysql.
In our office we run a Access database. We would now like to
synchronize Access with mysql.

Further there are plans to synchronize multiple Access databases
over the internet or a dial-up connections.

Does anyone know a good tutorial for these topics?
Any first-hand experience in synchronizing online with offline
databases? (and offline - offline through the web)

Thanks

Dan

[txbakers]

I know you can link Access with an online/ODBC database, but I think you would need some type of program to keep them in sync.

I'm not sure about the problem you are trying to solve. In my situation, the online DB is the master, and the desktop the slave to be used when online is unavailable. Then, the problem becomes uploading the changed and new records when online again.

I thought about doing this with simple flag fields in the local DB, then, when it's time to sync, the script or program would just read and either update or insert the flagged records to the DB.

[dwidmer]

I have an address database on the web (mySQL) and the same thing
exists also as a MS Access database (local PC). Now I would like to
retreive the new entries from the mysql database and store them on
our local machine.

Then there is another database (access), which needs to be updated from
the first access database.

I think I have found a way to synchronize mySql and Access (OBDC drivers in
Microsoft Query), but I haven't figured out how to synchronize
two MS Access databases.

Dan