How to make an Access DB timeout and close

  • Thread starter Thread starter Ron
  • Start date Start date
R

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!
 
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
 
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.
 
Back
Top