Hello. Some context...
We have a company wide "MasterDatabase" that is about 80MB in size and has several queries and forms for importing/exporting data etc.
The database is currently shared via a file/folder sync service called DriveHQ. Each of the 4 or 5 remote users just syncs a copy of the .accdb file. Naturally, this causes a lot of headaches between file conflicts (two users opening at once) as well as accidental overwrites.
I am looking for a simple and hopefully cost effective way to split this database, and host the back end on some sort of cloud service. I have been playing with Sharepoint but I don't fully understand what's supposed to be happening. I've also looked at MySQL but the costs are pretty tough to digest.
The ultimate goal of course is that each of us can open our own front end copy to design queries and export data, etc. without worrying about conflicts as much. We use the data as read only about 99% of the time, and only add new data intermittently.
Thanks