myODBC for linking Access and mySQL

Updating a remote mySQL db from local MSAccess

[mipapage]

Hey all, I spliced this off of this thread [webmasterworld.com], as the topic has shifted a bit.

I have set up myODBC [mysql.com] and managed to upload an access database to a remote mySQL databse. It was fast, easy, and required no exporting magic.

Cool.

Now though, what I am finding is that once the table is up there, there doesn't seem to be too many options for updating the live db; you can link Access to the Live db, so that when you monkey around in access it automatically (on closing of a table) updates the live db, however I was hoping for more of a 'push a button at the end of the day' sort of solution.

Is this possible?

[Xoc]

Create a temporary table that all changes go into. Then at the end of the day merge the temp table into the live one.