Creating a scheduled task

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a scheduled task to run at the early hours of each
morning so I can run a fairly time consuming event before I get in. I have
read about the Windows Scheduler, but unfortunately as I'm on a work PC it
seems that it has been locked out from use, so is there any other way I can
run something automatically in Access??
 
Well, you could leave your Access application running (idling), and with a
Timer event, check every hour to see what time it is. (ex. is time between
1AM and 2AM?) When that time arrives, your code could be triggered.
An hour later, the time criteria would fail.

Seems as though that should be do-able...
hth
Al Camp
 
Having thought about it for a bit myslf, that was the only conclusion I could
come up with too, was just hoping for something a bit easier.

Cheers.
 
cdb,
Well... the easier method would be to use Windows Task Scheduler.
Someone else may have other ideas, but my solution is pretty reasonable.
Why not try it, and continue to wait for more responses. If you don't get
any more suggestions you can try a repost.
Using the Timer events is not that difficult (although every time I need
to use it I have to go back to Help for a refresher)
Try to just get it to set off a BEEP to start with... no need to
expirement with the real job.
Give it a go, we're here if you get stuck.
hth
Al Camp
 
Back
Top