schedule a macro

[santana]

I am trying to set up a macro that runs on a scheduled time. This is what I
entered:
"C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
Office\Microsoft Office Access 2007.lnk" “E:\ db1.mdb “ / x Macro1
When the schedule task runs I receive the following error message:
"The command line used to start Microsoft Office Access contains an options
that Microsoft Office doesn’t’ recognize". Any idea on how to fix?

 

[Steve Schapel]

Santana,

Your command line needs to point to the Microsoft Access program.
"C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
Office\Microsoft Office Access 2007.lnk" points to a shortcut of some sort.
Instead, it should be something like this:
"C:\Program Files\Microsoft Office\Office 12\Msaccess.exe"

Also, there appears to the two incorrect spaces in “E:\ db1.mdb “ which
should be “E:\db1.mdb“

Also, the quotes around “E:\ db1.mdb “ appear to be "smart quotes", as if
you have copy/pasted this from somewhere like a word processing or web
interface. You should re-type, using text quotes "".

Also, there is an incorrect space in:
/ x Macro1
It should be:
/x Macro1