In 20 years I've encountered precisely one Access Database that was very well designed, adequately documented, and implemented correctly - meaning people used a

In 20 years I've encountered precisely one Access Database that was very well designed, adequately documented, and implemented correctly - meaning people used a single instance on a specific machine, or Remote Desktop Protocol'd into same. Connecting to an Access database over a network from individual client apps is a recipe for pain as the database file gets locked, so then people start saving "copy of copy of copy USE THIS ONE" versions and you get divergent database backends with no clean way to merge. IME this always happens for business critical Access systems with no backup and documentation at the least convenient time, and suddenly it's IT's problem/fault. Yes you can connect to a SQL Server backend, but then it's IT's problem/fault/responsibility to maintain, and it takes Access out of the "simple enough for business users" domain. That said, as a rapid app development desktop tool Access can work very well if you know its limitations. It's somewhat surprising MS never made a 365 web-first equivalent, but that's probably because they'd rather charge for Dynamics 365 licenses and Azure SQL hosting.