Member Avatar for jaasaria

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

  • 3 Contributors
  • 3 Replies
  • 119 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by werks
Member Avatar for debasisdas

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

Member Avatar for jaasaria

any much more idea? to become more efficient.

Member Avatar for werks

try PM me

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.