autorun macro without opening access

T

Tracy

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

Steve Schapel

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.
 

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