Sync Access and Mysql tables

[neerjakhattar]

I have 2 Access databases which contain 10 tables in each.I want to make a sync of 2 tables from both of the databases with mysql tables.

In mysql I just have the same structure of those 4 tables and i need record from access databases tables.

Whenever anyone do any updates in access tables that update should automatically comes in mysql tables.

Please advice me what i can do to make a sync or link or trigger or anything so that I can get all the updated data from access tables

 

[SpentGeezer]

I would have mySQL tables linked to the database using an ODBC connection. Then you don't have to worry about syncing as the data is going straight in.

Spent Geezer

 

[Banana]

I agree with Spent Geezer - I've built an Access application using MySQL as backend to good effect and using it as linked table would be much less hassle than rolling out some kind of homebrewn synchronizing solution.