Multiple data bases.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three access programs that I have wrote. They share an employee
information data base but otherwise they do separate things. I would like to
have a switch board that will allow the user to access all of them. The user
can only use one of these at a time but I donot want them to shut down access
and restart a new MDB each time they switch between the programs. Is this
possible?. All these programs have been split and they are linked to the
employee file. Mainly what I want is to be able to open an mdb file from
another MDB file without leaving access even if it means programaticaly
closing the current MDB before opening the other and be able to reverse this
when I want.
 
I got a main MDB with several more MDB's, to access each one of them, I
created a reference from the main MDB to the other's. (open code editor, from
the menu bar select Tools > Reference, and add the other mdb's).
After adding the other MDB's, the main mdb will recognize all the functions
that are in the other MDB's, so if you want to open a form in another mdb,
you create a function on the sub mdb that call that form, and from the main
mdb you can run this function that will open that form.
So, you wont be oppening Access to run each mdb.
 
Back
Top