Running a macro as a Windows Scheduled Task

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.
 
S

Sharkbyte

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
 
A

aaron.kempf

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Task Information Dialog Box not making duration changes to task 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Running a macro as a Windows Scheduled Task 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Accessing Exchange via Task Scheduler run on a Server 0
Need Help with Macro Security 1
Scheduled Macro hanging 4

Top