The company I work for is likely going to have a site-to-site VPN setup for their Access database. The problem as I see it is that some employees will not have Internet access and will have to work with a copy of the database while offline.
What is the easiest way to get this offline copy of the database to sync with the one on the VPN? Keep in mind employees will have their own User ID so their data will always be different from anyone else's.
I was thinking of devising a method with VBA for Import/ExportText or XML and having it done that way, as I only need to add data to the tables. Would an update query somehow help?
Thanks for any and all help!