How to make an Access DB timeout and close

[Ron]

Is there some type of code that can be implemented to make
an Access DB look for user inactivity and close down their
session after a specified amount of time?

Thanks!

 

[Alex Dybenko]

Hi Ron,
i think you have to implement this by your self - just make some public
function which will be called from form open events, form current, whatever
users normally do in your application. and in this function you just reset
some static variable, which incrementing in a hidden form timer event say
every 10 seconds or 1 min. if it greater then xx mins - then docmd.quit

HTH

 

[Douglas J. Steele]

http://support.microsoft.com/?id=128814

 

[jhardy66]

You may find this demo from Candace Tripp's website to be useful.
http://www.candace-tripp.com/download/logoff2k.zip


Jonathan Hardy

 

[Guest]

I used to use something like this in a form:
set the timer to the desired interval in milliseconds,
say 9000;
on the OnTimer event have the code that closes the
application;
on the OnCurrent event, have a line that resets the timer
to the desired interval, so every time the user paged up
or down, the timer interval would be reset.