Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Way to log out users automatically if inactive for set period of time

Posted on 2003-03-19
Medium Priority
Last Modified: 2008-03-06
Hello. Looking for a way to automatically log out users out of an Access db who are inactive after a certain amount of time (say 10 minutes), or if that is not possible, after a set period of time regardless of activity. We are running Win 2000 server and most users are on thin client terminals running XP, but some are on pc 's & laptops with XP or 2000 if that matters. Okay with VB solution, but I'm a little green, so be gentle:)Thanks for any help.
Question by:MilburnDrysdale
LVL 18

Expert Comment

ID: 8168343
Not a easy job.  You'll want to set some global variable to current DateTime after each key click/action.  Everyten minutes, you'll want to compare current DateTime to this global variable.  If the difference is 9:59 or greater, then boot 'em out.
LVL 11

Accepted Solution

joekendall earned 225 total points
ID: 8168454
This site has an example for Access 97/2000. It is under Detect and Logoff Idle Users.




Author Comment

ID: 8168979
Thanks! Went into event procedure of the idle form and changed it to 5 minutes, and it worked like a charm. Thanks again!

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question