simultaneous updating of data locally and on webserver.

sakmer
sakmer used Ask the Experts™
on
I have 3 locations using access, who periodically have to upload data to a database(sql server) as well as download any data and reconcile that data.
 
  Have thought about a solution, any changes to the client database at individual locations would also be done at the webserver, by opening a simultaneous connection, if the network(Cable/DSL connection) is down it would keep the updations as a dirty record to be updated when the connection is established.
  The changes affected on the webserver will also be downloaded at the same time and according to the location and the local (client side) database updated.

   Is it a good solution and what can be the possible pitfalls that I have to guard against? Any suggestions would be highly appreciated.
  Thanx in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
XML reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/htm/dom_reference_2kdh.asp

i would try using the IXMLHTTPRequest object.
http://msdn.microsoft.com/library/en-us/xmlsdk/htm/xml_obj_ixmlhttprequest_8bp0.asp

we have started using this method as opposed to standard TCP traffic, as HTTP is (normally) firewall safe.  so we carry on XML conversations from either ClientApp to ServerApp, or ClientApp to WebApp.

That second link has some decent examples.
Éric MoreauSenior .Net Consultant
Top Expert 2016

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept Tator's comment as answer.
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
emoreau
EE Cleanup Volunteer
Finalized as recommended.

RotaredoM
CS Mod @ EE

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial