Connecting 2 connection using MySql and access
 

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..

Re: Connecting 2 connection using MySql and access
 

you need to create two connection objects. Insert in access and if connection exists open the second connection and repeat the step1 again.

Re: Connecting 2 connection using MySql and access
 

any much more idea? to become more efficient.

Re: Connecting 2 connection using MySql and access
 

try PM me