Hello all,
I have experience using Access for multiuser purposes within one network in an office, but I am now curious as to what is the best approach for using Access when users travel and will not necessarily have access to the network a database back-end would be hosted on?
I am using Access 2010, and currently all data inputted is first recorded onto paperwork which is then manually added on to the Access database back in the office, but we would like to explore the idea of data entry on-site (wherever a person goes), where they won't necessarily have Internet connection. It would be a complete hassle to have to keep a copy of the backend on all devices that has to be updated constantly once all new entries from all devices have been appended to a master copy of a database.
We are a relatively small operation, and at most, 12 devices are to be taken out of the office to perform tasks, and we would like to find a way to enter data on those devices wherever they are, and then have them sync once they can connect to the office network.
I have tried researching options such as hosting on a cloud, and using services such as Sharepoint and what not, but it's just an overwhelming amount of information that I can't sort out since I'm not sure on what direction to take in the first place.
If anyone could suggest what my options are and include resources that I can read up on, that would be greatly appreciated.
Thank you very much.
EDIT: Suggestions with minimal cost would be preferred :P