How to grab MS Access data into Mysql and vice versa?

[lisa_alias]

hi everyone.

I'm new to PHP and i need some help.

I'm developing an online ordering system, using PHP and MySQL database, which requires me to integrate with MS Access database to get some data . for example : application status.

fyi, another system is developed using ASP and MS Access database to keep track of the application status since the status are always changing.

i have to grab the application status of a particular record and update the MySQL database. this has to be done sort of the 2 databases are 'linked' together.

any update/new records inserted into MySQL will be known by MS Access and any status update in MS Access will be known by MySQL. something like that..

is it possible to link the 2 different databases?
how am i going to do it?

thanks.

[sun818]

Link the two databases via ODBC. In Access, there is a query wizard tool called "Find Unmatched Query Wizard". You can use this tool to find missing records in one table that are present in the other based on a unique key you identify like RecordID.