Summary

To run a Microsoft Access macro using the Arcana Scheduler, you must have the Scheduler start Microsoft Access, load the proper database, and then run the macro.

To do this, specify the path to msaccess.exe as the Application in the Scheduler. For example:

c:\program files\microsoft office\office\msaccess.exe

For the Command line parameters, specify the path and name of the database that contains the macro and the name of the macro using the following syntax:

"database path and name" /x "macro name"

For example:

"c:\my documents\mydatabase.mdb" /x "MyStartupMacro"

Be sure to include the quotation marks around the database path/name and the macro name if they contain spaces.

More Information

This will cause Microsoft Access to start, open the specified database, and run the specified macro. If you want Access to close when the macro finishes be sure to include the Quit command at the end of the macro or implement some other method of closing Access. Otherwise Access will remain open until you manually close it and the Scheduler will report that the program is still running.

If the macro you want to run is the AutoExec macro for the database, you can omit the "/x" and macro name from the command line.

For more information look for "Startup command-line options" in the Microsoft Access online help.