People use spreadsheets as databases, but they're really not.
If you've never used a tool like Access, it's hard to explain just how powerful it really is for ordinary people.
If you've never used a tool like Access, it's hard to explain just how powerful it really is for ordinary people.
In some ways, it's a hark back to the day of a really 'thick' client that was a server, middleware and client all in one.
Looks like there are some additional configurations that MS actively supports: https://support.microsoft.com/en-us/office/ways-to-share-an-...
If I had to throw together a reasonably robust data entry form in a time crunch today and could connect to the DB engine via ODBC, I'd probably still use Access for that.