Running a Macro from Windows 2000 Task Scheduler

D

Don Hicks

Hello,

I've got an Access '97 database, and I'd like to set up the Windows 2000
Task Scheduler to run a macro in it on a nightly basis.

I'm having difficulty making the process work.

So far, this is the data I've set up in the "Properties" box for the Task
Scheduler:

Run: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "D:\Program
Files\Subfolder1\Subfolder2\DatabaseName.mdb" /x m100_OpenTestForm

and Start In: "D:\Program Files\Subfolder1\Subfolder2"

So, you can see that the database is located in a different drive, labelled
"D", while Access itself is on the "C" drive.

This combination works as a shortcut on the desktop, but not as a scheduled
task.

I have tried several different options for the "Start In" folder, including
one that matches the "C" drive specifications, but to no avail.

Can anyone help me out?

Sincerely,
Don Hicks
Portland, Oregon
 

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

No Current Record Error, Scheduled Task 4
Scheduled Task Access Error 2
Windows Task Scheduler and Access macros 2
schedule a macro 1
windows task scheduler bypass longin 2
Running a report using Windows Scheduled Tasks 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Schedule Macro 4

Top