Can a form in an Access MDB call other separate Access MDB's (with their own startup forms)

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 ?
Who is Participating?
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Yes ity is possible to do what you want. I prefer to use the ShellExec API to open the other database.

See: Start an app with ShellExecute
proffittwareAuthor Commented:
I will try and let you know.
proffittwareAuthor Commented:
Thank you very worked well.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.