How to run a procedure in a database from code in another DB?

[dsatino]

Basically, there is a pre-existing procedure in a DB. I want to to be able to run this procedure from a different DB.

Can this be done?
If so, how?

[ADezii]

Yes it can be done. Let's assume that you have an External Database named Test.mdb in the C:\Test Folder, namely: C:\Test\Test.mdb. To Execute a Public Sub-Routine named CountTablesInDB() in the External Database (Test.mdb), execute the following Code from the Current Database:

Dim appAccess As Access.Application
 
'Create instance of Access Application object.
Set appAccess = CreateObject("Access.Application")
 
'Open Test Database in Microsoft Access window.
appAccess.OpenCurrentDatabase "C:\Test\Test.mdb", False
 
'Run Sub procedure.
appAccess.Run "CountTablesInDB"
 
Set appAccess = Nothing

[dsatino]

Perfect. Thanks a million.