schedule a macro

S

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?
 
S

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
 

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

Similar Threads

Autorun a macro 1
Scheduled Task Access Error 2
No Current Record Error, Scheduled Task 4
DLookUp Format 7
Compact & Repair 4
Schedule Macro 4
The macro XYZ cannot be found? 0
Database Corruption 10

Top