guyzz i wanted to make 2 connection in my inventory system. using mysql and access.

i wanted to use the mysql as my main database..and if their no internet connection it posible save first the data in my access..

and if their an internet connection it will update and stored again in the mysql..

any suggestion? and i really needed code asap..
a function that will check the connection and also will update the record in every table..

thxx in advance and truly needed ur help expert..