automatic running of macros

[Dragon_Silveroak]

I have a database for my business that imports the previous day's
information. This is done with a macro. My question is, is there any way to
have the macro run automaticly durning off hours? Idealy I would like it to
run at midnight and be all done by the time I get into the office in the
morning.
Thanks!
DS

 

[Steve Schapel]

DS,

Probably the best approach is to use Windows Task Manager, or some other
scheduling software (for example I have found
http://www.splinterware.com/products/wincron.htm very good), to handle
this by defining an event scheduled to run at midnight. The syntax for
the Command Line for the scheduler to run, will be something like this...

"C:\PathToAccess\Msaccess.exe" "C:\PathToDb\YourDb.mdb" /x NameOfMacro