batch to start MSAccess

  • Thread starter Thread starter cuong hoang
  • Start date Start date
C

cuong hoang

I'd like to utilize a batch file to start a certain macro
at certain time.
Thanks for the tips.
Cuong
 
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.
 
Back
Top