Setting a Blackout Time to Block Database User Logins

In this Microsoft Access tutorial, I will show you how to set a blackout time to prevent user logins during specified hours, ensuring your database remains available for maintenance or backup.

Sami from Windsor Locks, CT (a Moderator) asks: [Followup to Force Shutdown video]: I would love for you to show how to do a blackout period where we only store time without a date portion. This way every day between the two times specified, the system will kick users out and also prevent them from logging on.

Members

In the extended cut, we will specify the shutdown message and timer interval for the shutdown form. You'll learn how to customize the message to indicate either a normal shutdown due to maintenance with a longer timer or an immediate shutdown during blackout periods. Additionally, I will show you how to set which days of the week the blackout times apply, suitable for varying maintenance schedules.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  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

• Force Shutdown

Links

• TimeValue
• MoveSize

Recommended Courses

• Access Developer Courses

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, blackout time setup, prevent user logons, Access database security, automated logoff, user access control, prevent database login, database maintenance automation, user logoff automation, configure logoff times, maintenance window, multi-user database, user login restrictions, manage database access, schedule user logoff, daily maintenance period