Can you program Access to automatically close if not in use

[Noreene Patrick]

We are having a problem with mulitple users leaving an Access db open and then I am not able to make new reports, etc. without calling everyone to close their session.

Is there a way to automatically close a db if user has not used in certain amount of time?

Thanks, Noreene

 

[Pauldohert]

I am sure there has been a thread or two about how to do that.

http://www.access-programmers.co.uk/forums/showthread.php?t=76680

You may be better splitting your db into a FE/BE solution if its not already- there is a thread around of how to update the individaul FE with your changes.

http://www.access-programmers.co.uk/forums/showthread.php?t=111132

 

[The_Doc_Man]

If you have a startup form (see Help on startup forms), and if that form minimizes itself and hides itself, it can have a timer still active via VBA.

If your users always go through forms, it is no big deal to have each form reset a global variable that the timer checks. Say you set a 1-minute timer and your global counter (in a global module, of course...) is 15. Your hidden form counts down 1 count every time the timer goes off. Your OTHER forms reset the time to 15 every time the user takes some action that involves an event. If the counter ever reaches 0, the hidden form's timer routine can make the application do a QUIT.

 

[Noreene Patrick]

It Worked !!!!!!

Thanks To Both Of You Guys For All Your Help!!

Noreene

 

[The_Doc_Man]

Whoops! Good catch, Pat.

Yes, stop timers before updating things. Having that code active in the background cause you to run into the problem of updating an active object.