is there a tool to display relationships between tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Roger
    #1

    is there a tool to display relationships between tables

    I've moved all my tables to sql server2005 and I've created the
    appropriate relationships
    now I create links to two such tables that have a relationship into ms-
    acess97
    but when I add the two tables to the 'relationship' window, it appears
    as though my odbc dsn link doesn't bring across the relationship(s) ,
    so I just see two tables

    sql server has a 'diagram' , is that the best tool, or is there
    another ms-product that works better ?
    Tags: None
    • MGFoster
      #2
      Re: is there a tool to display relationships between tables

      Roger wrote:
      I've moved all my tables to sql server2005 and I've created the
      appropriate relationships
      now I create links to two such tables that have a relationship into ms-
      acess97
      but when I add the two tables to the 'relationship' window, it appears
      as though my odbc dsn link doesn't bring across the relationship(s) ,
      so I just see two tables
      >
      sql server has a 'diagram' , is that the best tool, or is there
      another ms-product that works better ?
      -----BEGIN PGP SIGNED MESSAGE-----
      Hash: SHA1

      There cannot be formal relationships between tables in 2 different DBs,
      that is a distributed DB and MS Access can't handle that; nor, I
      believe, can SQL Server.
      --
      MGFoster:::mgf0 0 <atearthlink <decimal-pointnet
      Oakland, CA (USA)
      ** Respond only to this newsgroup. I DO NOT respond to emails **

      -----BEGIN PGP SIGNATURE-----
      Version: PGP for Personal Privacy 5.0
      Charset: noconv

      iQA/AwUBR+nutIechKq OuFEgEQKIvACgvR NUkc5HniXG4M277 0UO9HY2cXcAoOX0
      CI5I0O9WVhvUhj8 BM8Oooui9
      =Umll
      -----END PGP SIGNATURE-----

        Comment

        • Roger
          #3
          Re: is there a tool to display relationships between tables

          On Mar 26, 12:35 am, MGFoster <m...@privacy.c omwrote:
          Roger wrote:
          I've moved all my tables to sql server2005 and I've created the
          appropriate relationships
          now I create links to two such tables that have a relationship into ms-
          acess97
          but when I add the two tables to the 'relationship' window, it appears
          as though my odbc dsn link doesn't bring across the relationship(s) ,
          so I just see two tables
          >
          sql server has a 'diagram' , is that the best tool, or is there
          another ms-product that works better ?
          >
          -----BEGIN PGP SIGNED MESSAGE-----
          Hash: SHA1
          >
          There cannot be formal relationships between tables in 2 different DBs,
          that is a distributed DB and MS Access can't handle that; nor, I
          believe, can SQL Server.
          --
          MGFoster:::mgf0 0 <atearthlink <decimal-pointnet
          Oakland, CA (USA)
          ** Respond only to this newsgroup.  I DO NOT respond to emails **
          >
          -----BEGIN PGP SIGNATURE-----
          Version: PGP for Personal Privacy 5.0
          Charset: noconv
          >
          iQA/AwUBR+nutIechKq OuFEgEQKIvACgvR NUkc5HniXG4M277 0UO9HY2cXcAoOX0
          CI5I0O9WVhvUhj8 BM8Oooui9
          =Umll
          -----END PGP SIGNATURE-----
          all my tables are in sql server... so I'm not trying to implement
          relationships across databases

          I just want a way to graphically view the tables / relationships like
          the 'relationships' function in ms-access

          and like I stated, sql server has a 'diagram' function that looks
          similiar, it's just bulky to work with

            Comment

            Previous template Next
            Working...