By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,360 Members | 3,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,360 IT Pros & Developers. It's quick & easy.

Calling Access 2003 from cmd file via Windows Scheduler

P: n/a
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

Nov 28 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 28 '05 #2

P: n/a
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.

Nov 28 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.