I do not know if this can be done. I am using Access 2003
I have two separate MDB's that I would like to call from a "Main" mdb. Like a main menu.
The reason (instead of combining tables from the two separate MDB's) I would have a MDB with a Main menu, that would have two buttons that would open the either one of the separate MDB's.
Can this be done ? With Shell ?
I would like the called programs quit once done and go back to the main program.
Can you give me an example of how to achieve this task ?