I have a table - Parcels - that contains 250,000 records. I have
several databases that need to use this table. In Access I would create
a comon database with the parcels table in it and then link the table to
each of the databases that need to reference it.

How is this linked feature attained in SQL Server 7? Do I create two
databases and then open two connection objects (Dim con As
ADODB.Connection) and reference the tables in stored procedures or
embedded sql using regular - say - inner join syntax?

Thanks,

John Wood