Inactive Shutdown

[AccessNub]

Hi All,

I have been using the ever popular Inactive Shutdown form that I found of the web for about a year, the problem I am having is that it doesn't seem to always work.

I intentially left the database open 2 days ago and it still has not shut itself down, its set to a 6 hour timer.

The only thing I can think to do is change the DoCmd.Quit acQuitSaveAll to DoCmd.Quit acQuitSaveNone.

Do you folks have any other suggestions to the control or maybe another way to shut down after idle?

The real issue its causing is a lame ldb file that won't go away, which prevents the server from creating a backup of the access file.

 

[RuralGuy]

There are several dozen forms on the net for shutting down an inactive mdb. What method is your code using for detecting inactivity? Can you change it to 2 minutes and get it to work? What version of Access are you using? What OS do you use?

 

[AccessNub]

There are several dozen forms on the net for shutting down an inactive mdb. What method is your code using for detecting inactivity? Can you change it to 2 minutes and get it to work? What version of Access are you using? What OS do you use?

oh i suppose all that info is relevant =)

access 2000, win2k

im using the one from http://www.peterssoftware.com/isd.htm

you load up a form with a timer on it on open hiding.

it works most of the time, but sometimes it doesn't, im hoping to either fix the one im using or find a better one...got anything up your rural sleeve?

 

[RuralGuy]

I'll look at Peter's software but MVP Jeff Conrad has a few links listed.

 

[AccessNub]

I'll look at Peter's software but MVP Jeff Conrad has a few links listed.

wow, that link is Godly, youda man

 

[RuralGuy]

Peter knows how to write software so I'm not sure what the problem might be. I would try a smaller time frame, like maybe 1-2 hours and see if it still gives you an intermittent result. Did you have a form open in your test? His software works two different ways depending on whether or not there is a Screen.ActiveControl.