PDA

View Full Version : Comparing ms access 2000 db with mysql db



maghiel
Nov 9th, 2005, 08:22 AM
Here's the situation:
I've got a program in ms access with a huge db behind it. i made a form which dumps the data of the ms access db in a mysql db.
but as the db is huge, it takes like 10 minutes untill the program is finished dumping the db.
So what i want to do is compare the access db with the mysql db, and only dump the new and changed data in it. linking tables is not an option: the user has to have control over when the mysql database needs to be updated.

thnx in advanc!