Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2005
    Posts
    13

    Consolidate MDBs

    Over a period of time I developed several stand alone applications
    I would now like to combine them into one overall application.

    Can I set up the main form to select the application you need to work with.


    Set the relationships to all the tables in all applications .

    For instance in app A request a report from app B with out going back to the main form and running app B.

    If this can be done is there a limit on the number of tables that an app can have.

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Well I don't know exactly what you mean by "select the application you need to work with", but what you CAN do is have import all your objects except for tables into a single front end and then link the tables to the various MDB files.

  3. #3
    Join Date
    Oct 2005
    Posts
    13

    Consolidate MDBs

    John F,

    Thanks for the reply.

    I have stand alone MDBs. Call them A & B


    While in the A mdb I would like to run a report in the B MDB with out having to open the B mdb and running the report.

    I hope this is a clearer than my original post.

    Bob

  4. #4
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Well you could accomplish that via automation. For example:

    Dim appAccess As Access.Application
    Set appAccess = CreateObject("Access.Application.10")

    appAccess.OpenCurrentDatabase "C:\Access\northwind.mdb", False
    appAccess.DoCmd.OpenReport "Catalog"
    appAccess.CloseCurrentDatabase
    appAccess.Quit acQuitSaveAll
    Set appAccess = Nothing

  5. #5
    Join Date
    Oct 2005
    Posts
    13

    Consolidate MDBS

    John F

    Again thanks.

    I think that info is what I need to get started.

    Bob Hall

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums