Macro Execution from Windows Scheduler

[TomT]

I have some large queries that need to be run off hours. I have setup a
macro to run them all.

How can I trigger the execution of this macro from windows scheduler?

Thanks,

TomT

 

[Steve Schapel]

Tom,

Set the Command Line in the task scheduler like this:

"C:\Program Files\...\Msaccess.exe" "C:\YourFolder\YourDatabase.mdb" /x
NameOfYourMacro

 

[TomT]

Steve,

Thanks!!! Works like a champ.

TomT

Tom,

Set the Command Line in the task scheduler like this:

"C:\Program Files\...\Msaccess.exe" "C:\YourFolder\YourDatabase.mdb" /x
NameOfYourMacro