autorun macro without opening access

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

Is it possible to schedule a macro to automatically run each month without
even opening the database?
 
Tracey,

No this is not possible.

However, you could use Windows Task Manager, or one of the many
third-party scheduling utilities, to run the macro. You would probably
need a command line in the scheduler something like this...
"C:\Program Files\...\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /x NameOfMacro
If you put a Quit action as the final action in the macro, it sort of
amounts to the same thing as not opening the database.
 
Back
Top