Working with two or more database files

[boonjade]

I have two .mdb files; A.mdb and B.mdb. How do I link them together so that
I can access a form in B.mdb from A.mdb. (The main menu is in A.mdb but a
significant number of forms are in B.mdb and I would like to be able to
select a form from B.mdb from that main menu). Is this possible?

 

[Jeff Boyce]

Is there a business reason why you don't simply import the forms from B into
A?

While it is possible to do, you'll also need to connect the data on which
the forms are based, making it available to both A and B. Again, it would
be simpler just to import the forms and do everything in A -- you probably
want a compelling need to use such a split approach.

 

[Bruce]

If you use a single startup screen to get to either school
system's database, from the user's point of view either
choice is an entirely separate program. You are the only
one who needs to know the truth. If the problem is the
number of concurrent users I doubt you will fix that by
sharing database objects between two separate files.

 

[Bruce]

Consider keeping the student file small in terms of number
of fields. Just name, address, etc. Reporting
information could be in another table, with a foreign key
field to match the primary key from the student table.
Once that relationship is established, you could make the
form for reporting a subform of the student form. You
could do something like having a command button on the
student form make the subform visible. Once the student
is in senior high a different command button could be
visible to show a different subform. Details aside, if
you have one student table you can link it to any number
of other tables, and you won't have to rewrite the table
when the student goes to the senior high school.