AUTOMATING QUERY

  • Thread starter Thread starter MDAVIS
  • Start date Start date
M

MDAVIS

I successfully created a query but need to run it
throughout the day is there way to have it auto run or
will a SQL- Pass Throuh Query work.
Thanks Mark
 
You can use a scheduling program like Arcana, SKEDEZY Or Launchpad to kick
off any executable at any time. Sometimes the built in scheduler actually
works too. (The AT scheduler in NT fails with linked ODBC tables though!)

You simply use a command line like:
"C:\Program Files\Office10\MSaccess.exe" "C:\mydocs\mydata.mdb" /x
"MacroName"

The Macro Name can call Runcode so you can execute just about anything you
can think of.
The last part of the macro should be Quit to exit Access.
 
Joe, cam I automate the query using VBA or is their a
trigger in access. Do you if sql - pass through will auto
update
Mark
-----Original Message-----
You can use a scheduling program like Arcana, SKEDEZY Or Launchpad to kick
off any executable at any time. Sometimes the built in scheduler actually
works too. (The AT scheduler in NT fails with linked ODBC tables though!)

You simply use a command line like:
"C:\Program Files\Office10
Click to expand...
\MSaccess.exe" "C:\mydocs\mydata.mdb" /x
 
Please re-read my previous response.
It explains how to automate the running of the query by using a macro
command line switch and a scheduler to kick it off.

The type of query is irrelevant. If you want it to be SPT then it can be.
 
Back
Top