Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automatic save & exit with long idle time 1

Status
Not open for further replies.

TechGreek

Technical User
Aug 3, 2006
1
US
Our Access 2000 database is used by 3 people in our office. One of them has a bad habit -- foretting to log off the network and the database when finished working.

PROBLEM:
Is there an easy way to get Access to do the following:

1. Track when there is over 30 minutes of idle time.
2. Automatically save the current record.
3. Automatically exit the database.

POSSIBLE SOLUTIONS:
I tried using the TimerInterval (in Forms) property, but that is good for only 1 minute maximum. It did automatically close the database after 1 minute of inactivity using the OnDirty event procedure for a new record.

I also tried the technique "Set a maximum locking interval for a record" (Chapter 10, Section10 of O'Reilly's "Access Cookbook")
 
An advanced search with keywords 'detect idle' will return a number of posts. here is one:
Detect the length of time the system has not been used/ user is idle
thread705-1012106
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top