[AccessD] Trigger a macro

If you really need to, try this from Michael Kaplan
TSI SOON (Shut One, Open New) database add-in

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8

Or this works but not sure of all the ramifications.
Sub OpenmdbMacro()
'open macro in a second  mdb
  Dim objAccess As Object
    Set objAccess = CreateObject("Access.Application")
       'objAccess.Visible = True 'to see what's happening man
     objAccess.OpenCurrentDatabase "C:\Temp\test macro 2003.mdb", False
               objAccess.DoCmd.RunMacro ("MyMacro")
   Set objAccess = Nothing
End Sub

Johncliviger at aol.com wrote:

>Hi all
> 
>How do I run a macro in a Backend AXP database from its FrontEnd? It must  be 
>simple but my brain can't hack it
> 
>regards
> 
>johnc
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada