Nightly Autorun Macros - Error

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Alan,

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

Try it with the /x bit.
 
Back
Top