Shared Database advice needed
So I have a user who's trying to share an Access database they've created with 2-3 other users. They dropped it onto a Sharepoint document library (via OneDrive desktop app) and obviously it's not working well. So they called me for some help.
I've not had to deal with Access files in the modern M365 days (I remember them being a thing back when we had file servers on-prem, and I remember hating Access. But it's been a solid decade since I even thought about it).
I've done some quick googling to see what the recommended method for this would be, but it's clear it's a whole thing and not very straightforward. Advice I've seen ranges from "convert to Sharepoint lists" all the way to "my god, never use Sharepoint, put it in Azure!" and then various other opinions and articles about AWS, non-Access dbs like SeaTable or Zoho, etc. The user isn't opposed to re-doing the database in something other than Access, it's just what she was learning in an online training course she picked up.
Has anyone out there managed something like this? It's such a small use case that spinning up a VPS or VM in Azure for a DB server is overkill, they have no on-prem server at all and currently use M365/Sharepoint for Exchange, document libraries and not much else. There's unlikely to ever be more than 2-3 consecutive users in the database. Is there a simple way to host the Access file in Sharepoint/Azure and let them access it via the Access desktop app? Should I tell her to rebuild it in something more multi-user/cloud friendly? Any help or guidance would be appreciated.