Problem with Schedule Task

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Professor - 27 Jul 2007 14:28 GMT

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.

Reply to this Message

Jeff C - 27 Jul 2007 16:34 GMT

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

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

Signature

Jeff C
Live Well .. Be Happy In All You Do

> Hi -
> I am trying to create a schedule task to send a daily Report vcia MS
[quoted text clipped - 15 lines]
> Any help would be appreciated.
> Thank You.

Reply to this Message

The Professor - 27 Jul 2007 17:02 GMT

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.

> you should check your macro to make sure it works, then change:
>
[quoted text clipped - 19 lines]
> > Any help would be appreciated.
> > Thank You.

Reply to this Message

Dirk Goldgar - 27 Jul 2007 19:43 GMT

> The macro works correctly - I have been executing it manually
> everyday.
[quoted text clipped - 5 lines]
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

The Professor - 27 Jul 2007 20:44 GMT

That did the trick - thank you.

> > The macro works correctly - I have been executing it manually
> > everyday.
[quoted text clipped - 15 lines]
> or it may not -- I don't know where Office 12 normally installs itself,
> even if you didn't do a custom install.

Reply to this Message