Turned computer off

[Allison]

I have been trying with your help to run a autoexecu Macro
that goes out and automatically runs two ODBC tables
within the Access application.

I went out to windows in the scheduled task - run in box
and filled it with the following:

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "H:\QUERYRUN.mdb" /x autoexecRunQuery

Also within the scheduled task I set the above to run at
6:30 am daily. Today I opened my tables and they were not
refreshed with the new data??? What am I missing is it
the network or should I leave my computer on for this
process to work?? Is the above correct??? Please explain
in detail what I'm doing wrong???

 

[Cheryl Fischer]

If the Scheduled Task was set to run on your computer, then Yes, you must
leave your computer on.

 

[Allison]

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.EXE" "H:\QUERYRUN.mdb" /x autoexecRunQuery


Is the above correct? I will need this information in the
run in path box.

Is there a way that I could leave my computer off under a
different server and it run. We have shared servers that
run and update information all day and night long???

 

[Cheryl Fischer]

If you want to leave your computer off, you will have to set up the
Scheduled Task on the server to run from the server. AFAIK, this requires
Administrator privileges. If you have a network administrator, he or she
may be able to help you.