Access Inquiry

[Guest]

I need to create a referential table that connects from one mdb file to
another.

Is it possible to link from one database to another? We need to find a way
to have status reporting capabilities that link form one info source to the
next.

 

[Guest]

You can link tables from other mdb's. All you need to do is right click in
the table window, in a blank area and not on top of a table. Select Link
Tables. It'll bring up a browse box. Find the mdb you want to link a table
from, open it (in the browse window and select the table/s you need and hey
presto.

HTH.

 

[Dirk Goldgar]

All you need to do is right
click in the table window, in a blank area and not on top of a table.
Select Link Tables. It'll bring up a browse box. Find the mdb you
want to link a table from, open it (in the browse window and select
the table/s you need and hey presto.

I didn't even know you could do it that way! I've always use the
File -> Get External Data -> Link Tables... menu items. Thanks for
sharing a nice tidbit.

 

[Guest]

First of all, much thanks! You are a genius.

Secondly, does this automatically update if any changes are made in either
of the original tables?

 

[Dirk Goldgar]

Secondly, does this automatically update if any changes are made in
either of the original tables?

Yes.