Not exactly a VB issue but I don't know where else to post this.

I am designing an application for a multi-location health care organization. Each of 4 remote locations will generate small transaction volumes, no more than 50 per day. Dial up connections will be used once per day to synchronize with home database. Conflicts needing arbitration will be rare - or never.

I need to specify the DBMS. We routinely use Access (Jet), SQL Server 7.0 and MSDE. Can you share any real world replication experience with any of them?

Thanks in advance


John Kisner
J.L.Kisner & Co., Inc.
Greenville, SC, USA
864-233-6941