How to shutdown Access if User has it idle for given time

[MFS]

I've been doing a huge amount of programming and updates to my database and now I'm running into the problem where I cannot update my DB because users are keeping it open when they go home for the evening.
Does anyone have some VB that will close and shutdown the DB if the user has it idle for a given time?
This DB does not allow the users to add or edit data, it only provides graphs and trends for a thermal plant operation. PLC's are sending data to a SQL DB and Access is used for my front end.
Any help would be appreciated,

Mike

[June7]

Multi-user db should be split design. Each user should run their own copy of frontend. You have a master for editing purposes then distribute new version.

What is PLC?

[MFS]

A PLC = Programmable Logic Controller.
I do have a Master for editing but for me to distribute it I need the users to close out so that I can update the currently used DB. I then delete, save the revised DB on the Network, to the same file with the same name so that all the users shortcuts on their desktops continue to open the DB.

[June7]

I faced this question long time ago and gave up. Seems its not too difficult to determine that Access is running but determining what file(s) are open is not. What I discovered is, essentially, closing the db means killing the app and you could really upset some users. Just because Access is running doesn't mean it's your database.

In my db, code automatically downloads new version if needed when user opens frontend. When I deploy new version, I don't worry if they still have their copy open unless I know there are design edits that would cause their current version to fail. In which case I do edits when everyone is gone and I know all frontends are shutdown. I have code that records each user login and logout into a table so I know if there is one sitting open. Every user is just a few steps away so if I do have issues I can yell at them. Review https://www.accessforums.net/code-re...end-33331.html

[MFS]

Okay, This makes some good sense. And honestly would be a better way than what I was trying to do.
I will review the attached thread and see how I can get it to work for me.

[IncidentalProgrammer]

I found this while searching for some codes I needed a while back: https://www.accessforums.net/code-re...life-7572.html. I'm planning to use it on my projects, but I haven't gotten far enough along with them to do it, so I haven't personally tested it. Everyone in the thread seems to love it though, and it sounds like it might help with your problem.