this will start access then maybe you could run the macro. maybe this will start you.
ActivateMicrosoftApp Method
Activates a Microsoft application. If the application is already running, this method activates the running application. If the application isn't running, this method starts a new instance of the application.
Syntax
expression.ActivateMicrosoftApp(index)
expression Required. An expression that returns an Application object.
index Required Long. Specifies the Microsoft application to activate. Can be one of the following XlMSApplication constants: xlMicrosoftWord, xlMicrosoftPowerPoint, xlMicrosoftMail, xlMicrosoftAccess, xlMicrosoftFoxPro, xlMicrosoftProject, or xlMicrosoftSchedulePlus.