Access link table in SQL Server?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Access link table in SQL Server?

  1. #1
    John Wood Guest

    Access link table in SQL Server?

    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





  2. #2
    Jason Langston Guest

    Re: Access link table in SQL Server?

    John,
    I don't have a lot of time to get into the specifics but this should help
    ....
    First of all if the "central" database is on the same server you can refer
    to it's tables by fully qualifying the name.
    ie. from the "linking" database write this VIEW - SELECT * FROM
    servername.CentralDatabase.dbo.Parcels
    the fully qualified name is [servername].[databasename].[owner].[tablename]
    For more info look in the Books Online under "distributed queries". This
    will also point you in the right direction if the "central" database needs
    to be on a physically seperate server.
    HTH,
    Jason

    John Wood <jwood@co.sarasota.fl.us> wrote in message
    news:39E49C70.C6A31348@co.sarasota.fl.us...
    > 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
    >
    >
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center