Link tables

Is there a way to incorporate link tables in SQL Server similar, if not
the same way Access ineracts with them?Can you explain what a "link table" is?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"EESP" <johnson4@.wwu.edu> wrote in message
news:1145653487.044408.232680@.g10g2000cwb.googlegroups.com...
> Is there a way to incorporate link tables in SQL Server similar, if not
> the same way Access ineracts with them?
>|||EESP wrote:
> Is there a way to incorporate link tables in SQL Server similar, if not
> the same way Access ineracts with them?
If the table is located on the same SQL Server instance that you are
using then no kind of linking is required. You can access those tables
by using a three-part name in the form:
database_name.schema_name.object_name.
If the table is located on a different server or on another instance or
not in SQL Server at all then you can create a "linked server" (a
virtual server that corresponds to an OLEDB data source). Lookup linked
servers in Books Online.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--