I'm currently in the process of creating a database that will be located in some of our branch offices and need to be able to synchronize our headoffice database with data from the branches. Right now I'm working on an Import/Export routine using persisted recordsets and looping through them to validate whether or not to be imported. I can see some problems occurring with deleted records and I know that ideally the database should be on some sort of network but our LAN is not accessible by our branches.

My question finally is what would be the best way to Import/Export data? Persisting recordsets are easy but I'm wondering if there's a more efficient way.