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.