Timed Event

[Dion]

I am somewhat new to this but... I was wondering if
anyone knew of a way to set a timed event to occur. What
I am trying to do is open a program called Monarch and
import a file into an Access 2002 table at 6:00AM. Any
ideas would be extremely helpful in pointing me in the
right direction. Thanks in advance.
Please only respond in this newsgroup.

 

[Kevin]

If you leave the Access database up and running, you can
set a timed event on an open form. The form can be hidden
if you like, but it has to be open. Create a form, then
set a VBA module or a macro to run once a minute ( Timer
interval = 60,000). Have the code or macro that is run
check the current time and if it is 6:00am, call another
module or macro which imports the desired data.

There may be other ways, but that is how I have tackled
something similar.

Hope that helps!