How to Sync data between Access and Mysql tables?

[neerja khattar]

I have total 3 databases.One is mysql and other 2 are of access type.

I have 10 tables in each of the databases.
I want to sync 2 tables from both access databases with mysql tables.

whatever updates are happening in access databases tables it should come in mysql tables

1. student- table name
2. school - table name
both are in database 1
1. contact details - table name
2. departments - table name
in database 2

1. student
2.school
3.contact details
4.departments
all four tables with same structure is in mysql

i want to sync the access data in mysql tables.

[stepterr]

Looking into how to link the databases. Here's a link that may get you started. http://itc.virginia.edu/desktop/web/mysql/msaccess.html

[neerja khattar]

I already know this method.I do not want to use it.In this my access data is the main data and people are using that database they will upload new stuff so I want mysql table to automatically get that data instead of me refreshing or doing anything.