Windows Schedule Task to open Autoexecu Make Table

[Allison]

I set my windows schedule task to open the
autoexecu Make table query(autoexecuRunQuery) and it did
not work????

I have XP, explain how to use the windows scheduler??

I also have a questions as to how will the scheduler know
to go to my Access File and pull the above Macro???

When I used wizard it provides this: Click the program you
want Windows to run? To see more programs Click Browser.
The list only allows you to select Applications ie.
Microsoft Access, Excel. How will the scheduler
determine within Access, go to the database
entitled "QUERYRUN" and run the query named
autoexecuRunQuery)?

 

[Steve Schapel]

Allison,

I think the command line of your scheduler needs to be something like
this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\QueryRun.mdb" /x macroname

The /x switch tells the scheduler to run the macro. I assume you have a
macro with an OpenQuery action to run the query? So you would enter the
name of the macro in the expression above in the place of 'macroname',
and also need to put in the correct folder paths.

Your macro will also need a
SetWarnings,No
action before the OpenQuery action, to suppress the display of the
action query confirmation messages, as the query will be run unattended,
and also possibly you will want a
Quit
action after the OpenQuery to close the database down again.

 

[Allison]

I need more assistance on using the Scheduled Task in
Windows:

My path name to access appears like this:

"C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Access.link"

This information appears in the Run Tab in the scheduler
popup box.

There is also a StartIn box with the same information.

I have 2 questions:

1. How will I find the path to my autoexecu query?

My database is entitled "QUERYRUN" and the query name is
autoexecuRunQuery the database is in my H drive.

2. Which box should I fill in the information or should I
fill in both boxes (Run Box and StartIn Box)

 

[Steve Schapel]

Allison,

The path to Access you have suggestes is not correct. It should be
something like this...
"C:\Program Files\Microsoft Office\Office11\Msaccess.exe"

This should go in the Run box of the scheduler, along with the database,
which it looks like should be...
"H:\QueryRun.mdb"

and then the reference to the macro, i.e. /x autoexecuRunQuery

So, in summary, the scheduler Run command line should be something like....

"C:\Program Files\Microsoft Office\Office11\Msaccess.exe"
"H:\QueryRun.mdb" /x autoexecuRunQuery