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.

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA
• If Then
• Split Your Database
• TempVars
• Track Log On

Links

• ISO Date Format

Up Next

• Force Shutdown, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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 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