Scheduled macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David S - 07 Aug 2007 18:00 GMT

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?

Reply to this Message

SteveM - 07 Aug 2007 18:44 GMT

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

Steve

> 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?

Reply to this Message

David S - 07 Aug 2007 20:12 GMT

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.

> Schedule it from the server desktop or get an Administrator to set it up for
> you.
[quoted text clipped - 6 lines]
> >
> > Any ideas?

Reply to this Message

Albert D. Kallal - 08 Aug 2007 04:40 GMT

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

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

Vicky - 12 Sep 2007 17:52 GMT

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?

Signature

Vicky

Reply to this Message

Raymond - 18 Oct 2007 20:55 GMT

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

> 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
[quoted text clipped - 7 lines]
> Nothing works except killing the process.
> Any suggestions?

Reply to this Message