[AccessD] External MDBs

Max,

    My sample db named ExternalDbAutomation might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    You might find it quite close to what you are seeking. Some of its features are outlined below.
 
Best wishes,
A.D.Tejpal
---------------

Sample Db (ExternalDbAutomation)
================================
    The sample set consists of two mdb files, representing local and external db's respectively. Access XP version incorporates programmatic insertion of password argument for opening the external db (In earlier versions, password argument is not available for OpenCurrentDatabase method). 

    So long as both db's are in the same folder, the local db will automatically detect the path of external db

    Clicking the command button captioned "Go To External Db", on switchboard form in local db, hides the local access application and results in either of the following -
    (a) If external db is not yet open, a new instance of access application is created, in which external db is opened and its switchboard form is displayed.
    (b) If external db is already open, it gets un-hidden and its switchboard form is displayed.

    In external db, opening of form F_Reports results in loading of all available report names (from AllReports collection) in the list box, facilitating print/preview.

    In external db, clicking the go-back button (or closing the switchboard form) results in hiding of external db and un-hiding of local db.

    Any of the following actions in local db ensures closure of external db (if still open) -
    (a) Click command button for closing external db.
    (b) Close switchboard form of local db.
    (c) click command button for closing local db.
    
    Versions - Access XP & 2K (Both in Access 2000 File Format)
    References - DAO 3.6
================================

  ----- Original Message ----- 
  From: Max Home 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, October 06, 2006 11:03
  Subject: [AccessD] External MDBs

  Thanks Marty,
  What I had in mind was a central MDB which (depending upon options set) would allow users access to other MDBs from a central menu.  Once the option was enabled and the user clicked on the menu item, the called MDB would then open in exactly the same way as if it had been opened from Windows.  
  Once the called MDB was exited, then the central MDB would re-open back at the menu.

  I have set References, but it only appears to give me access to the code
  within the called MDB and not the full functionality.

  I will have a look at MDA Addins.

  Thanks

  Regards
  Max