Hi, I'm trying to run a sub called "Update_DB_Information" in a module in another database. The code refernces the DB fine (if I replaces the ###'s with a DoCmd it works) but I don't know how to call a sub this way. I've tried just putting the sub name, and putting the module name then sub name but I can't get it to work, can anyone help, thanks, Tom.
Sub UpdateExternalInfo(strDB As String)
' Return reference to Microsoft Access Application object.
Set appAccess = New Access.Application
' Open database in Microsoft Access.
appAccess.OpenCurrentDatabase strDB
appAccess.##########
MsgBox "DB Information is Updated"
appAccess.CloseCurrentDatabase
Set appAccess = Nothing
End Sub
Sub UpdateExternalInfo(strDB As String)
' Return reference to Microsoft Access Application object.
Set appAccess = New Access.Application
' Open database in Microsoft Access.
appAccess.OpenCurrentDatabase strDB
appAccess.##########
MsgBox "DB Information is Updated"
appAccess.CloseCurrentDatabase
Set appAccess = Nothing
End Sub