I am developing an application to synchronise data between remote MS Access 2003 databases and SQL Server. I read data into a dataset, and then update SQL from that. The problem is that some of our WAN connections are slow, and doing this from a single program is not effective. I believe that the best solution would be to develop a 'server' application to install at the remote sites that will get the dataset, and then pass this back to the central 'client'. Similarly, with updating the other way, the 'client' getsthe dataset and passes it to the 'server' which updates the local database.
1. Is my thinking correct, or is there a better way of doing this ?
2. I haven't a clue how to write client / server code - are there any samples that I may use as a guide ?