Hi,
Back in February, I built a small Access Database for one of my clients. I'm not a database expert by any stretch of the imagination. I had to google and use these forums to figure out how to do every single step. At the time my client had some pretty out there suggestions for how his three locations (a total of 6 PC's) were going to use the DB. He wanted a multi-user DB; however, he insisted we do it using GoogleDrive. I explained that GoogleDrive was a file backup system, and would not allow more than one person entering or saving at the same time, but he insisted it would work.
With the limitations of GD in mind, I set it up so that there were only two PC's (mine and one other) who would use the full Access program to update the file. The rest were restricted to Access Runtime, which only gave them search capabilities. We have avoided conflicts, so far by notifying each other when a full Access user is in the program.
Recently I had a conversation/confrontation with the client, where he insisted that all PC's should have the ability to enter and edit data! Grrrr! Ok, so I painstakingly explained how a DB and GD work and why you cannot have a true multi-user DB in this situation. He asked me to "fix it"!
As I mentioned...not a Database person here. I know we need a host for this 4MB database, but I have no idea where to look. It goes without saying that it will have to be cheap. The reason he insisted on GD was that it was free. It will also need to have enough security to protect sensitive customer information. It also has to be simple...I don't want to have to learn coding or anything like that.
Does anyone have any suggestions of where I can look?