Close Access after period of inactivity/idleness

I have administrative rights in a company of 50+ employees, and I need to be able to automatically close Access after a period of inactivity.  Does anyone know how to accomplish this.  This database is not connected to SQL Server.  
pmleAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Nope.  Access does not have this ability.

What can get you close is to have a form running in the background, with an ourrageously long Timer interval (say 1 hour (in seconds) x  1,000 ), that closes the application.  You'd have to build the logic to determine if the app has actually been used during this time period.

Hope this helps.
-Jim
0
 
dannywarehamConnect With a Mentor Commented:
I use something slightly different - but still along the same lines

Set your form timer as Jim suggests
then have an OnMouseMove event that resets the timer:

Me.form.timer = 0
Me.form.timer = 10000   ' your original value

I have found a glitch with this though - sometimes (especially in Acc97), you have to put this in the mouseover event of every control on your form....

:-(

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.