Close Access at specific time

[JeroenMioch]

Hi guys,

I'd like to close my database daily at a certain point in time but im having trouble with this.
I can do it using the Form_timer but my db has many forms and reports so i'd have to enable that at every form and report. Thus not an option.

So i tryed making a macro :

IF TimeValue("19:00") THEN
<close database>

It doesnt work at 19:00 so i thought i might have to make it Autoexec but that doesnt work either.
It only closes the database right away when opened.

Anyone a clue to achieve this ?

[ranman256]

In a form, put a text box for the shutdown time...txtShutdownTime

form property TIMERINTERVAL = 1000 ( 1 second)
in the ONTIMER event put code

if format(Time(),"hh:nn:ss") = txtShutdownTime then docmd.quit

[JeroenMioch]

In a form, put a text box for the shutdown time...txtShutdownTime

form property TIMERINTERVAL = 1000 ( 1 second)
in the ONTIMER event put code

if format(Time(),"hh:nn:ss") = txtShutdownTime then docmd.quit

But if that form is not open, then the shutdown will not occur i guess ?

[NTC]

Open a hidden form so that you can guarantee it to be having the timer event.

the reason that this is not easily accomplished is that the concept of Access fundamentally is that it is 'event driven' i.e. has a user running it. It is not an exe app running on a server. So it is not an ideal vehicle for timed events.