Shutting off automatically if no activity after a time

[petko]

Hi,

I run a database with table on the server and 7 users linked to the table. I've recognised that users frequently let their application running even if they are out of the office.
Is there a simple way I could recognise this from the vba and shut off automatically like after and hour operation-less time?

I would not like to drive this from the forms because I have more than 250 of them and it would take too much efforts to change the code only for this reason.

Thanks in advance

Peter

 

[RuralGuy]

The first thing my applications do is load a housekeeping form invisible. It is that form that runs a timer to kick people off of the system if I want.
Here's a link where Jeff Conrad has put together a big list of ways to do that: http://www.accessmvp.com/JConrad/accessjunkie/kickoff.html

 

[petko]

Hi RuralGuy,

Thanks for the list, I found what I was looking for.

Peter

 

[RuralGuy]

Excellent! Thanks for posting back.