On Timer Close Database

[Dave Elliott]

I would like to know how to on the On Close Event of my form, named
frm_ExitNow make the control in my table
named tblLastUsed (LastUsed) is the control name change to the Date(),
which is the default value.
What I am really trying to do is if the user does not close the form, then
the database close after 15 minutes, if they close the form then they have
another
15 minutes before the form opens again and the timer starts to close the
database again.

 

[Trisha B.]

I use a download available at http://www.peterssoftware.com called Inactive
Shutdown Control. It works well, but if you're still coding, comment out the
timer code until you're done with everything else. It causes some
interesting, but unwanted, behavior.

Hope this helps,
Trisha