Auto Execute MS Access Macro with Windows Scheduler

J

JA

The Windows scheduler opens the MS Access application.
How can I get it to run a specific macro? Please help.
 
K

Kevin K. Sullivan

If you call the macro AutoExec, it will run whenever the database is opened,
manually or automatically.

If you call the macro MyMacro, set the following command in Windows
Scheduler:

"C:\FullPathToAccess\msaccess.exe" "C:\FullPathToDatabase\database.mdb" /x
MyMacro

HTH,

Kevin
 

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

Help with vba autorunning macro? 2
help with scripting 2
Access Access, Error Due to Versioning Differences 0
task scheduler macro 7
Run a VBA Sub using Windows Scheduler? 5
Bypass database login and Autoexc macro 1
Access macro to compact and repair 1
Open Web page with MS Access macro 1

Top