Calling Access Macros

Dexter1 · Post by **Dexter1** » Fri Aug 04, 2006 10:08 pm

Currently we use Macro Scheduler to call a .bat file which in turn calls an MS Access macro. Is there a way to call the Access macro from Macro Scheduler and cut out the middle man (the .bat file)?

Bob Hansen · Post by **Bob Hansen** » Sat Aug 05, 2006 1:05 am

You can start Access and tell it to call a macro like this:
Access.exe path\database /x macroname

Example:

Code: Select all

Run Program>C:\Program Files\Microsoft Office\Office11\MSAccess.exe C:\Program Files\Microsoft Office\Office11\Samples\Northwind.mdb /x macroname

Alll of the info in the example is actually on one line, but may be broken where there is a space character.

Dexter1 · Post by **Dexter1** » Sat Aug 05, 2006 7:40 am

Perfect, thanks!

Bob Hansen · Post by **Bob Hansen** » Sat Aug 05, 2006 1:41 pm

I forgot to mention that you could also have an AutoExec macro in Access vs. calling a macro on the command line.