Hello, I am at the design stage of designing an application. There is an MS DB in place currently, but it's old, and certainly not optimised, and as we're expanding to other sites as well, I was asked to create something solid. The data in a couple tables needs to be synchronised between sites. Currently, only two sites are using the DB, but up to 15 locations will be joining. I've looked at replication, which seems like a good solution, but with many pitfalls. One of the problems is that there will NOT be a way to connect over a LAN (the PTB in their "infinite wisdom" have decreed that for confidentiality issues, they weren't going to grant anyone access to the server where the "main" db resides...). So, can replication by email be done? Seems like it would be a bad idea, fraught with risks of corruption? Currently, they export data to CSV, then run an append query from the CSV. This is kinda ok for someone who has done it, but it's cumbersome (may be done as often as daily!). I'd like to automate the process and make it easier, so it's foolproof (well, I know, the moment I do something foolproof, they'll come up with a better fool, but...) Any ideas would be appreciated.