By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,756 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

is there a tool to display relationships between tables

P: n/a
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 ?
Mar 25 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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:::mgf00 <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+nutIechKqOuFEgEQKIvACgvRNUkc5HniXG4M2770UO9H Y2cXcAoOX0
CI5I0O9WVhvUhj8BM8Oooui9
=Umll
-----END PGP SIGNATURE-----
Mar 26 '08 #2

P: n/a
On Mar 26, 12:35*am, MGFoster <m...@privacy.comwrote:
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:::mgf00 <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+nutIechKqOuFEgEQKIvACgvRNUkc5HniXG4M2770UO9H Y2cXcAoOX0
CI5I0O9WVhvUhj8BM8Oooui9
=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
Mar 26 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.