-
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.
-
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.
-
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
-
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
-
Consolidate MDBS
John F
Again thanks.
I think that info is what I need to get started.
Bob Hall
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules