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

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
 
G

Guest

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

Access Saved Import details 5
ODBC - call failed during runing of macro 1
Macro to Automate Notices in Outlook Calendar 4
Run Macro every hour? 2
How do I create a macro to open/run WordMailMerge option from Acce 3
schedule a macro 1
Macro to Run Table after batch processing 1
Need Macro to run cross tab query and export to access table 2

Top