Force Shutdown
Force Shutdown 2
Force Shutdown 3

Hi Gary, I don't know any "Access way" to kick out the users. If they are already logged out, then you can open the BE as "Exclusive" and do whatever, changes, updates you want or a backup. My limited testing wouldn't allow the users to get to the linked tables, but I can't remember exactly what happened. It was testing in Access 2021 awhile back.

In my Menu form, I have a timer that checks for a BE flag that the system isn't available. The menu can't close if some "jobs" are still open, otherwise it shuts down Access on the FE. The same flag check is done for the Login form and all the other forms, updates and reports (jobs). The jobs will all gracefully shutdown when they see the flag in their timer procedures. When they are done closing, the menu will again do its timer procedure check and shut Access down.

It's very rare that I get a single db to exceed 2gb, especially for business applications. I had 40 client's data on my old db server, along with the applications and logs and I never came close to 1gb. I didn't "purge" data either. And this was with around 50 employees entering data every workday for the clients as well as downloads of our client's customers and their sales data for twenty years. Good design helps keep the db to a reasonable size. Despite that, in Access I do keep logs in their own db, and I may consider putting some universal data (countries, postal codes, addresses, etc.) in their own db too at some point as referential integrity isn't all that important in these rather static tables.

I still have the tool "LDBViewer".  This is a utility from 1997 that when used, tells you what users have the database open.  It's old, but still works.  My email is [email protected].  EMail me if you want me to email you a copy of it....

There's some more discussions on monitoring users in another forum post: Detect multiple users

I did find this code online. And it seems to work. Well, it just tells you who is connected. I haven't tried it in a multi-user environment.