Nightly Autorun Macros - Error

G

Guest

I have read the previous posts about setting up a macro to run nightly, by
using the task scheduler and

"C:...Access.exe" "Pathtofile\name" /MACRO

When I run it with a file path that is on my C it runs OK, but when I change
it to a Network location I get an error that says
"The command line you used to start Microsoft Access contains an option that
Microsoft Access doesn't recognize...Exit and restart Access using valid
command-line options"
If I run the command for the networked file without the MACRO it opens
without the error. The error only comes when I have the /Macroname with it.

Any ideas? Do I have to include a path to the Macro as well?
 
S

Steve Schapel

Alan,

The correct syntax is...
"C:...Msaccess.exe" "Pathtofile\name" /x macroname

Try it with the /x bit.
 

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

Top