link to a link of a link...

[Gern Blandston]

Here's a linking question:

database '1' (all are .mdb) contains a table called table
1;
database '2' has a linked table to database 1/table 1;

Is it possible for database '3' to link to the linked
table in database '2' (the link to database '1'/table 1)?

Is it possible to link to a query instead of a table (e.g.
create a query in database '2' that displays the linked
table 1, then link database '3' to that query in database
2)?

Thanks!

 

[John Nurick]

Hi Gern,

It's not possible: linked tables in one mdb can only link to real tables
in another mdb. If you want in database 3 to join data from tables in
database 1 and database 2, create a linked table in database 3 for each
of the tables, and then build a query joining the linked tables.

Here's a linking question:

database '1' (all are .mdb) contains a table called table
1;
database '2' has a linked table to database 1/table 1;

Is it possible for database '3' to link to the linked
table in database '2' (the link to database '1'/table 1)?

Is it possible to link to a query instead of a table (e.g.
create a query in database '2' that displays the linked
table 1, then link database '3' to that query in database
2)?

Thanks!

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.