Running a macro as a Windows Scheduled Task

  • Thread starter Thread starter Phil Hellmuth
  • Start date Start date
P

Phil Hellmuth

I have an MS Access DB residing on a server, and have scheduled a task
in Windows via Task Scheduler to run a macro in the DB. However, if the
server is not logged onto, the task doesn't run. Are there any work
arounds? Can I create a Windows service to perform the task? VBScript?
If so, how?

Thanks in advance.
 
I'm not aware of a way for the Scheduler to run without an account logged on.
A way around the issue would be to log on an account, and then use
Ctl-Alt-Del to lock the machine. This will allow the Scheduler to run and
still keeps the machine locked to unauthorized users.

Sharkbyte
 
you can run c:\program files\msaccess.exe c:\mydatabasename.mdb /X
macroname

this will allow you to write a batch file to do this and it works like
a charm
 
Back
Top