using task scheduler for running a macro every month

[keyur]

i want to run access macro every month. i am following the instructions on
http://www.google.ca/search?q=cache...EN-US;230575+task+scheduler+access+file&hl=en.

it worked perfectly fine on my home computer but not on my company's network computer. (i am using task scheduler as i cant see the 'Schedule' service as its mentioned on tht site).

This is what my .bat file shows. I dont know if i have change anything for getting it work on the NT server.

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
\viewkind4\uc1\pard\f0\fs20 C:\par
CD\\Program Files\\Microsoft Office\\Office10\par
MSACCESS.EXE C:\\db1.mdb /x Course\par
}

any help will be great. thanks

 

[WayneRyan]

keyur,

For the computer at work, is the Access executable located in the same
folder as your's at home? I noticed the Office10 folder name.

Also, does the machine at work have a db1.mdb located at the root of
the "C" drive?

db1.mdb is a pretty "common" name for a db, are you sure that's right?

Wayne

 

[MarcelMegens]

Try this

See attached doc.
Basically use the wizard of the Task Scheduler to fill out the basic stuff. Then alter the properties of the created icon.

If this doesn't work, let me know what error message you get.

 

[keyur]

Thanks guys, i just got it to work.
just removed the stuff which it added automatically and changed to
C:
CD\Program Files\Microsoft Office\Office10
MSACCESS.EXE "C:\db1.mdb" /x Course

I think i was missing quotation marks.

got another question though, the Command Prompt window stays open too. is there a way to close it once Access is open.

Thanks again.