Link Two Databases Question?

[Dave Elliott]

I have two databases that I wish to link. One is split and the other is not.
The databases have some of the same table names also.
How do I approach this?

 

[Albert D. Kallal]

You can simply link the tables to which ever database you want. Of course,
we are talking about the front end here.

So, in the mdb file that your users (or you) runs, you simply add more
linked tables. You are allowed to link to as many different mdb files
(usually the back end, but they don't have to be) as you wish.

Further, each of the many back end files can have the same table name, but
in your front end they must be given a different name.

So, while in the tables view, simply go new->link table. You an then browse
and link to any table in any mdb file your wish at that point.