By Richard Rost 26 days ago
Schedule Forced Shutdown. Kick Users Out! Byeeee...
In this Microsoft Access tutorial, I'm going to teach you how to schedule a forced shutdown time for all users logged into your Microsoft Access database. In Part 1 we will create a server information table so the admin can set the shutdown date/time. We will split our database. We will make it so that if users close the main menu, the database shuts down because this is where our timer event will be running and we don't want that form closed with the database still open.
Colin from Pasadena, Texas (a Platinum Member) asks: We have a backup routine that runs every night at 3:00 a.m. The problem, as I'm sure you're aware, is that some users go home for the night and forget to log out of their database, and our backup routine will not back up any open Microsoft Access files. It also makes it hard for me to do maintenance in the morning if I come in early and there are still people logged into their machines. Then I have to run around and shut down databases. We only have 15 users, but it's still a pain in the behind to have to log out three or four people every day. And of course, they don't listen to me. Is there a way that I can have Microsoft Access force users to shut down the database at a specific time, say 11:00 p.m.? No one's ever here outside of regular business hours, except for me, of course - the lonely IT guy.
There is no extended cut, but here is the database download:
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
TechHelp Access, forced shutdown, Access database maintenance, backup routine, close Access on timer, VBA programming Access, server-side shutdown scheduling, ACCDE encrypted database, multi-user database management, automate Access shutdown, nightly backup Access, kick out users Access, TempVars, environment username Access, network file sharing Access, Kick users out, Kick Users Off, Remote shutdown, Boot users, Force restart, Force reboot, Force shutdown
Subscribe to Force Shutdown
Get notifications when this page is updated
|Keywords: TechHelp Access, forced shutdown, Access database maintenance, backup routine, close Access on timer, VBA programming Access, server-side shutdown scheduling, ACCDE encrypted database, multi-user database management, automate Access shutdown, nightly back PermaLink Force Shutdown in Microsoft Access