sync Access offline db to online mysql db (1 Viewer)

Hi,

Not sure if this forum is correct place for this thread but here goes.

I am developing a website for someone that already has an offline Access database which they currently use.

They need me to import the data into the website which is fine. However, they want to be able to automatically sync online with offline when they've made changes with the offline version. Problem is I want to develop the site with php/mysql and i'm wondering if there's a way Access will sync with a mysql database which is located on the web server at the touch of a button?

Many thanks for any info!

There is no automatic way to do it. But it can be done (I've done it). The basic concept is that you produce CSV or tab-delimited text files that are uploaded to the server and then you run a server-side script that imports the text files into the MySQL database.

It's not at all a simple process. It works best if one of the dbs is a slave of the other (i.e., no updates are being done to that db).