batch to start MSAccess

C

cuong hoang

I'd like to utilize a batch file to start a certain macro
at certain time.
Thanks for the tips.
Cuong
 
J

Joe Fallon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top