Scheduled macro

[David S]

I am trying to schedule a macro to run nightly using Windows Task Scheduler.
The macro runs fine if I run it manually when I'm logged into the server.
Unfortunately, if I schedule it, then log off the server, it just hangs.

Any ideas?

 

[SteveM]

Schedule it from the server desktop or get an Administrator to set it up for
you.

Steve

 

[David S]

Sorry, left that part out. It is scheduled from the server desktop and I am
the administrator. The account the job is scheduled with has domain admin
rights. The job will run manually, just not as a scheduled job.

Thanks for the suggestion though.

 

[Albert D. Kallal]

Can you use a code in a module in place of your macro?

I explain how to run code in a module from the windows scheduler here:

http://www.members.shaw.ca/AlbertKallal/BatchJobs/Index.html

 

[Vicky]

Albert, Your VBscript idea works. I've been following David S' posts
because I've been having the same problem getting MS Access to run
import/exports when using the Task Scheduler. This has been bothering me for
weeks, but your solution worked for my application. Thanks!

The only issue left is that MSACCESS.EXE stays running as a process (and
there is a lock on the database) even though the VBscript has the Quit
command (accessApp.Quit). I've tried multiple solutions (running an Exit
Macro with the Quit command, using a DoCmd.Quit in the called module, etc).
Nothing works except killing the process.
Any suggestions?

 

[Raymond]

Vicky, I had the same problem and I created a macro that would do what I
wanted and then I exported the macro as a shortcut to my desktop (or
whereever the task scheduler is pointing) and I would point the scheduler
directly to the macro and the macro would execute fine.

Raymond