How do I automate/schedule an Access macro to run nightly?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a lengthy macro I would like to run every night at midnight so that it
will be done/updated when I come to the office in the morning. Is this
possible to automate?

Thanks
 
Use Windows Task Scheduler, or one of the many third-party scheduling
programs available today, to run the macro using a command line like
this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /x macroname
 

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

Similar Threads

Windows Task Scheduler and Access macros 1
Scheduling a Macro to run 1
ODBC - call failed during runing of macro 1
MS Access 2007 - Macro Action to Open Another Database 1
Importing .dbf File Into a Table Using Macro 1
Access error for scheduled macro 0
Nightly Autorun Macros - Error 1
Automate a macro 4

Back
Top