Autoexec macro and Task Scheduler

[Joel Wiseheart]

I have a database file, that consists only of linked
tables, make-table queries, and the resulting tables from
the queries (Which are subsequently linked into a
different .mdb file).

The reason is that the linked tables come from an old
Fortran system (ManMan), and the ODBC drivers for the real-
time data link are incredibly slow. To speed things up a
bit, I have some make-table queries, that need to run at
night, to refresh the data in the local tables.

What I tried to do was to have an autoexec macro that:

-Sets warnings to off,
-Runs all of the make-table queries,
-Sets the warnings back on, and
-Close the Access application when complete.

If I run it manually, it works great.

Then, I was going to try to use the Task Scheduler in
Windows 2000 Advanced Server to open the database file
every day at midnight.

I set up the scheduled task, but neither the database nor
the Access application itself appear to be opening. Can
the Task scheduler be used for this? What is the proper
syntax for the command line?

I've tried:

\\ServerName\FolderName\FileName.mdb

and

"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
\\ServerName\FolderName\FileName.mdb

and

msaccess.exe \\ServerName\FolderName\FileName.mdb

etc., but nothing seems to make the database open. The
task says it's running, but I don't see any Access windows
opening, and I don't see any versions running in the
backgroud in the Task Manager | Applications or Task
Manager | Processes tabs.

Help? Thanks!

 

[Steve Schapel]

Joel,

Try:
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"\\ServerName\FolderName\FileName.mdb"

If this doesn't work, try renaming the macro to something else, and
then doing like this...
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"\\ServerName\FolderName\FileName.mdb" /x macroname

- Steve Schapel, Microsoft Access MVP