Home  Fees/Services  Access 2010 Template  Access Tutorial  Access Download  Articles  Search  Contact  Privacy  Links

Automatically Logout Users Access Database
How to Detect User Idle Time or Inactivity






Visual Basic Tutorials:
Access-Google Earth
Age Calculation
Change To Proper Case
Email via Gmail #1
Send Gmail Email #2
Inactivity Logout Code
Outlook Email
Read Email Access
Email Attachment
Send Outlook Email
Running Sum
Concatenate Records
Stock Quotes
CreateQueryDef
Find Database Path
Detail-Master Update
Data Field Validation
Field Value New-Old
FindFirst
Access Version
Global Variable Parameter
Global Variables
Active Labels
Files List Box
Mail Merge
Quick Sort
Recordset Filters
Reference Form Field
Select Case
Access Transactions


Visual Basic Function Examples


Updated On 2/22/2017 4:59:42 AM


User Inactivity Timeout

Automatically Logout Users

Ever wonder how you can automatically logout idle users of an Access database? 

Checking on the inactivity time is pretty simple...

1)  Create a little form which gets open with the HIDDEN attribute when the database opens.

2)  Set the interval timer to some amount of time.  Remember the interval timer is in milliseconds so 1000 ms is 1 second.  I suggest you set it to about 30 seconds (30000 ms).



Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. We are kind of like Allstate Insurance - 'we have seen it before'.

Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.


3)  Create a visual basic procedure in the On Timer event of the form.

4)  Copy and paste the Microsoft.com VBA code for detecting user inactivity in this article: How to Detect User Idle Time or Inactivity

5) Find the line of code:   Const IDLEMINUTES = 2 
You can change the idle time minutes to whatever time in minutes you would like.  You might want to change it to a 20 for 20 minutes.

*** Now we have a downloadable Microsoft Access example database showing how to logout inactive users!  Go to our example download page for User Inactivity Logout VBA Code.

User Inactivity Timeout Logout










Blue Claw Database Design Downloadable Tutorial:
TransferText & OutputTo Microsoft Access Download.  








A Blue Claw Software Design Template:

Work Order Administration Software
 










A Blue Claw Database Design Article:

Software Risk Assessment
 

Microsoft Office:
MS Access 2000 Through 2016 and Office 365 & Sharepoint


Contact Information

Copyright 2000-2017 Blue Claw Database Design

Microsoft Access 2007, 2010, 2013 & 2016