Running a Macro from another DB.

[mixedguy]

Hi,

How would I run a Macro residing on a network database from my macro residing on my Hard drive database?

Thanks in advance.

 

[adam_fleck]

Running a macro in another Access DB

You'll probably need to use VB code to do this.

You could start a new module then put this code into it.

Public Sub run_Server_Macro()

    Dim servDB_path_name
    Dim servAPP As Access.Application

    servDB_Path_Name = "\\path\server_db_name.mdb"

    Set servAPP = GetObject(servDB_Path_Name, "ACCESS.Application")
    
    servAPP.DoCmd.RunMacro "name_of_server_macro"
    
    servAPP.Quit
    
    Set servAPP = Nothing

End Sub