Problem with Schedule Task

[Guest]

Hi -
I am trying to create a schedule task to send a daily Report vcia MS
Outlook.
I had this working before but got my pc re-imaged and now I have to
re-create the task.
I have this in the Run section:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and
Settings\dispatch\My Documents\Database\Daily_Svc_Revenue.mdb" /xDaily_Run

'Daily Run' is the name of the Macro

And have this in the Start in section:
"C:\Program Files\Microsoft Office\OFFICE11"

I am running Office 2007...

It just does not work - I am missing something.
Any help would be appreciated.
Thank You.

 

[Guest]

you should check your macro to make sure it works, then change:

...../xDaily_Run to ..../x "Daily_Run"

 

[Guest]

The macro works correctly - I have been executing it manually everyday.

Your suggestion did not work. I think it has something do with this
directory:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE

I do not have MSACCESS.EXE in this directory...
Could that be the problem?

Thanks.

 

[Dirk Goldgar]

In

The macro works correctly - I have been executing it manually
everyday.

Your suggestion did not work. I think it has something do with this
directory:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE

I do not have MSACCESS.EXE in this directory...
Could that be the problem?

If you're running Access 2007 (part of Office 12) now, and no longer
have Office 2003 (Office 11) installed, you'll have to change that path
to the new location of the msaccess.exe file. Search for this file on
your disk; it may be at

C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE

or it may not -- I don't know where Office 12 normally installs itself,
even if you didn't do a custom install.

 

[Guest]

That did the trick - thank you.

In

If you're running Access 2007 (part of Office 12) now, and no longer
have Office 2003 (Office 11) installed, you'll have to change that path
to the new location of the msaccess.exe file. Search for this file on
your disk; it may be at

C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE

or it may not -- I don't know where Office 12 normally installs itself,
even if you didn't do a custom install.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)