Time out

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.
 
D

Douglas J. Steele

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
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.
 
C

Cheryl Fischer

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
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.
 
G

Guest

Thank you, everyone, for your help. All suggestions were perfect and now it has made my Monday perfect!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top