Calling Access 2003 from cmd file via Windows Scheduler

[Pat_RI]

I am trying to call a macro using a command file by using Windows
Scheduler. I am able to run the command file and the macro runs
without issue if I doubleclick on the *.cmd file. When I try
scheduling the job to run via scheduler it appears that Accesss opens(I
can see MSAccess in the task manager window) but the macro is not
invoked. Does anyone have an idea what the issue can be? I am able to
call command files to run pl scripts thru scheduler and to run other
scripts I just am not able to run Access macros. Any help is
appreciated and please let me know if you need any further information.
I am an admin on the box and on the database.

thanks,
Pat

[Wayne Morgan]

It may be that the cmd file is finishing before the macro runs and Access is
being closed. What is the command line you are using in the cmd file?
Couldn't you just have the scheduled program call Access without using the
cmd file?

--
Wayne Morgan
MS Access MVP
"Pat_RI" <PA*****@YAHOO.COM> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I am trying to call a macro using a command file by using Windows
Scheduler. I am able to run the command file and the macro runs
without issue if I doubleclick on the *.cmd file. When I try
scheduling the job to run via scheduler it appears that Accesss opens(I
can see MSAccess in the task manager window) but the macro is not
invoked. Does anyone have an idea what the issue can be? I am able to
call command files to run pl scripts thru scheduler and to run other
scripts I just am not able to run Access macros. Any help is
appreciated and please let me know if you need any further information.
I am an admin on the box and on the database.

thanks,
Pat

[Pat_RI]

I believe I figured it out I didnt' setup the correct security on the
scheduled task. I use the .cmd file to archive, FTP, and log the files
that are created.