How can I start a macro in MS Access with database activities?

[brian.c.hunt (Brian_Health)]

Try this: Use the start process activty.
First argument is the .exe of access. example : “C:\Program Files\Microsoft Office\Office16\MSACCESS.EXE”

Second argument is the database file “”“C:\User\Myself\Path with spaces works\MyDB.accdb”“” + " /x macro_name_here"

Triple quotes allows spaces in the name but doesn’t allow /x. So to handle both cases, you triple quote the path, then add on a single quote string. Note the space at the start of the second string ‘/x’ is a command line argument that allows specification of a macro name. I sometimes get a message saying I don’t have exclusive rights to the DB which may need to be handled separately. However, this should start Access, and then run a macro inside the DB specified.

Here is the support document from Microsoft.

Command-line switches for Microsoft Office products