Time out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me, or at least point me in the right directin, for some code that will close Access if the computer is idle for a certain amount of time, say 15 minutes or more. I have some customers that will leave Access open while they go to lunch or leave for the evening, which "breaks" the database. Because they're still in it I can't access it to repair it and it really messes up my day. Thanks.
 
http://support.microsoft.com/?id=128814 shows one approach. (Don't worry
that it only states Access 2.0, Access 95 and Access 97: the same approach
will work with Access 2000, Access 2002 and Access 2003)

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Elaine said:
Can someone tell me, or at least point me in the right directin, for some
Click to expand...
code that will close Access if the computer is idle for a certain amount of
time, say 15 minutes or more. I have some customers that will leave Access
open while they go to lunch or leave for the evening, which "breaks" the
database. Because they're still in it I can't access it to repair it and it
really messes up my day. Thanks.
 
Elaine,

You might want to take a look at the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q210297

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Elaine said:
Can someone tell me, or at least point me in the right directin, for some
Click to expand...
code that will close Access if the computer is idle for a certain amount of
time, say 15 minutes or more. I have some customers that will leave Access
open while they go to lunch or leave for the evening, which "breaks" the
database. Because they're still in it I can't access it to repair it and it
really messes up my day. Thanks.
 
Thank you, everyone, for your help. All suggestions were perfect and now it has made my Monday perfect!!!
 
Back
Top