link to a link of a link...

  • Thread starter Thread starter Gern Blandston
  • Start date Start date
G

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!
 
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!
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top