open another database from a form

[LynneH]

I am trying to figure out how to open one database from another database form. I need to have a central database where I open various others and run macros.

[PianoMan64]

Is there a particular table with the database that you're wanting to open in the other database?

I need more information and specifications as to what the names of the database, tables, fields you're wanting to access and so on.

Let us know, then we would be able to give you a more specific answer to your question.

Thanks,

Joe P.

[ADezii]

If you wish to Open a series of External Databases as the Current Database in the Access Window, manipulate them in some manner, then Close each one systematically, you can use some simple Automation code. This is essentially a 3 step process. The OpenCurrentDatabase method enables you to open a Microsoft Access database from another application through Automation in the Access Window.

1. Declare a Variable as type Access.Application in a Standard Module:
   

   Public appAccess As Access.Application

2. Write code to Open the External Database as the Current Database, and perform some action:
   

   'Initialize string to database path.
   Const conDBPath As String = "<Absolute Path to Database>"
    
   'Create new instance of Microsoft Access.
   Set appAccess = CreateObject("Access.Application")
    
   'Open database in Microsoft Access window.
   appAccess.OpenCurrentDatabase conDBPath
    
   'Run Macro1 in the External DB
   appAccess.DoCmd.RunMacro "Macro1"

3. Close the Instance of the External DB:
   

   appAccess.CloseCurrentDatabase

4. This is just one of several Options.