Timeout

[Luis]

Hello.
I have a DB that is used for many users. Sometimes i have to do some changes
in the DB structure, but there are users that open the DB when they arrive at
work and closes the DB in the end of the day without having done any
operation.
Is it possible to implement a Timeout routine after 1 hour of inactivity in
the database?

Thanks

Luis

 

[Rick B]

Sure.

Just put a "docmd.quit" statemnt in a form's timer event.

You will need to make sure this form is alwas opened, so I would have it
open in hidden mode on startup of the database, if it were me.

Rick B

 

[Dave]

This can be frustrating to users who are using the database when the timer
event triggers.

A better way would be to create a hidden form that uses the Timer event to
monitor the actions on the active form for signs of use and triggering an
event after so many timer intervals return the same value.

Dave