Timed Out

[Guest]

I understand that I need exclusive access to make design changes. Is there a
way to set a time limit and kick people out after a period of time. I work
in an office and everyone minimizes the databases instead of closing them,
some even leave it minimized over night. (I do ask them to close it) If I
need to make any changes I have to go around and check everyone pc, and if
their pc is locked, the only way to get them out is to reboot. I usually
work on a copy of the database and export updates but I don’t think its very
efficient when I have to update a dozen queries and reports.

 

[Wayne Morgan]

You will find an example of detecting idle time in this KB article. You can
then do an Application.Quit when the time runs out, if you desire. You will
need to warn your users that if they leave any unfinished changes to a
record, that you will be canceling those changes and closing the database
after a certain length of time. Basically, if you start something, finish it
or lose it.

http://support.microsoft.com/default.aspx?scid=kb;en-us;210297