Is the sharing going on at the same physical location, or are you carrying that drive from place to place?

Same location. However, I do take the external drive home to work on modifications/bugs etc. The need to share it has decreased recently- only one person managing the art gallery, but I still need to get to it at home. I keep a backup copy on my PC but I'm very careful to only update the "master" on the external drive.

How big is the database (ACCDE) file?

9728 KB. Its tiny as databases go. We have around 3000 inventory items ( that we don't ever delete) and about 40 artists and we keep all sales, but the sales history is pretty small. Over time the sales history could grow but the inventory will not increase much.

I've actually been working on a way that you can share an Access ACCDB file for VERY SMALL databases, with VERY LIGHT usage using a shared folder on Google Drive. I'm going to put together a video on this in the near future. It can only be used by ONE PERSON at a time, and you have to be patient while the files synch, but I've got it working on a test database in my office.

Beyond that, YES, you can connect to MySQL. I personally prefer SQL Server. Yeah, I'm a Microsoft nerd. That's another video I'm going to be putting together in the very near future - how to set up an SQL Server instance on Google Cloud Platform. It's inexpensive and easy to do. You can also use a hosting service like GoDaddy, which is where I have my web site hosted.

This is great news Rick. I do back up the database using Google BackUp and Sync, which works fine, even with an external drive. One person at a time would work fine for us ( that's what we do now).
I would be very happy to use SQL Server Express ( free!) because the book I use a lot covers it in some depth. I might be able to use BlueHost to host it but we also have our domain with NameCheap. The latter possibly has space we can use. Its just a question of whether we can issue SQL calls to the database. BlueHost have MySQL functionality; that's the only reason I mentioned it. I'm not thrilled to have to learn a new database and I'm sure SQL Server express would be an easier transition. Keep me posted.

Shelagh: SQL Server Express is a good product for IN-HOUSE use. You can't connect to it from home unless you've got a static IP address at the office and open up a port in your firewall. You can get Windows Hosting from GoDaddy pretty cheap and host your SQL Server databases there. That's what I do. It's less than $10 per month. Well worth it - even if you don't use them for web hosting. The SQL Server alone is worth it. I'm definitely going to put together a video on how to do this soon. It's changed somewhat since I last covered it.

I have had my customers using Drop Box and Google Drive for years now. It's really easy to set up.
I have all of my custom access program setup so that the customer can move the back end data file anywhere they want then in the program i have a button they click and find that data file and re-connect to it.
The only thing bad is that yes only person can use it at a time and it is really bad about Corrupting the Database file. If you are going to have different office locations you are better to set up SQL server.

Ray: yeah, Google Drive is an option only for the smallest of databases and the most minimal usage. I had a situation where I wanted to be able to use a particular database from home and the office (back when I used to have an office). I was the ONLY person using it, and it took me half an hour to go from the office to home. So, putting the ACCDB file in a Google folder was a good option because no matter where I was, I didn't have to worry about anyone else corrupting it, and it had time to synch up when I moved from location to location.

Expert 24 covers transferring from a local access db to MS SQL Server.

What would I do without you, Alex? :)