In our office we have an Access customer database that is about 20MB big. People mostly use it from within the office's LAN, but some other team members are external and they currently have the following workflow:
- Ask somebody in the office to upload the file to an FTP server
- Tell others to stop making changes in the database
- Download the database, commit changes
- Upload it to the FTP server and tell the office that it's usable again
What is the easiest way to allow those people to make changes to that database without needing to resort to the methods above?
There should be no need for real "live" and collaborative editing, but the process should be fairly easy to learn for "normal" PC users and involve as little effort as possible for me on the developer/sysadmin side.