Closing Idle Database

[cdacey]

Hi,

Since Access seems to be very sensitive to abrupt disruptions on our network, I would like to set the application to close automatically if left idle for a specif time frame. Could anyone point me in the right direction on this.

Thanks Chris

 

[llkhoutx]

One way, on the Timer property of each form, using the timer Interval property, prompt the user for an alternative to quit or continue and he fails to answer or respond, have the program terminate. Another, you could also have each form, update a record periodically, and then at another interval check that record for last update. The latter, although more complex, is probably more difficult (just brute force of coding), but is most effective.

Although I don't have it, there's code around for multiple clocks on the same form.

 

[pbaldy]

I use this:

http://www.peterssoftware.com/isd.htm

 

[pcEars]

Thanks to Mile-O-Phile

http://support.microsoft.com/default.aspx?scid=kb;en-us;128814&Product=acc

 

[Mile-O]

No, thanks to MicroSoft.