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

Preserving Relationship window

P: n/a
Having spent ages sorting out the layout of my relationship window with
about 60 tables and getting it all tidy and with enough of the tables
visible to show the PK an FK relaionshipsOn a subseqent occassion, on
opening the relationship window, I found all the tables had shrunk so that
in most cases, only the table names were visible and the fields could only
be seen by "expanding" the table again.
I know you can print out the relationship window, but can the layout be
saved in any way

Thanks

Phil
Jun 27 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Apr 12, 6:33 pm, "Phil Stanton" <p...@myfamilyname.co.ukwrote:
Having spent ages sorting out the layout of my relationship window with
about 60 tables and getting it all tidy and with enough of the tables
visible to show the PK an FK relaionshipsOn a subseqent occassion, on
opening the relationship window, I found all the tables had shrunk so that
in most cases, only the table names were visible and the fields could only
be seen by "expanding" the table again.
I know you can print out the relationship window, but can the layout be
saved in any way

Thanks

Phil
If I needed a persitent clear diagram of MDB tables I would use a
hack.

1. I'd use the upsizing wizard to convert the JET db to SQL Server
(assumes I have some version of SQL Server; SQL-SERVER Express is
powerful and free.)
2. I'd download and Install SQL Server Mangement Studio Express.
3. In SSMSE I'd open the server and create a new diagram, loading all
the tables.
4. I'd ask the Diagram interface to arrange the Tables.
5. Presto I'm done.

Of course I've never done this but I think it should work well. The
only rough spot is the Wizard. MS claims it converts relationships; if
that's correct then the job should be pretty straight-forward.
The diagrams are great.
Note that I'm not recommending the conversion of the db to SQL-Server,
just using that capability to get SQL-Server's great diagramming
capability.
Jun 27 '08 #2

P: n/a
lyle <ly************@gmail.comwrote in
news:2a**********************************@f63g2000 hsf.googlegroups.com:
On Apr 12, 6:33 pm, "Phil Stanton" <p...@myfamilyname.co.ukwrote:
>Having spent ages sorting out the layout of my relationship window
with about 60 tables and getting it all tidy and with enough of the
tables visible to show the PK an FK relaionshipsOn a subseqent
occassion, on opening the relationship window, I found all the tables
had shrunk so that in most cases, only the table names were visible
and the fields could only be seen by "expanding" the table again.
I know you can print out the relationship window, but can the layout
be saved in any way

Thanks

Phil

If I needed a persitent clear diagram of MDB tables I would use a
hack.

1. I'd use the upsizing wizard to convert the JET db to SQL Server
(assumes I have some version of SQL Server; SQL-SERVER Express is
powerful and free.)
2. I'd download and Install SQL Server Mangement Studio Express.
3. In SSMSE I'd open the server and create a new diagram, loading all
the tables.
4. I'd ask the Diagram interface to arrange the Tables.
5. Presto I'm done.

Of course I've never done this but I think it should work well. The
only rough spot is the Wizard. MS claims it converts relationships; if
that's correct then the job should be pretty straight-forward.
The diagrams are great.
Note that I'm not recommending the conversion of the db to SQL-Server,
just using that capability to get SQL-Server's great diagramming
capability.
http://www.ffdba.com/northwinds.png

This took less than 5 minutes to create. obviously it's too big, and the
tables are too spread out. But they could be dragged and dropped wherever
we wanted them and a much more effective diagram could be produced in a few
mintes.
That diagram would persist in SQL Server.
Jun 27 '08 #3

P: n/a
Take a look at:
http://www.lebans.com/saverelationshipview.htm

NEW - Feb 04/2004 A2KSave-Restore-ModifyRelationshipWindow.zip is an MDB
containing functions to:

1) To allow the saving of the layout of the Relationship window to a table.
2) To allow the restoration of the layout of the Relationship Window from a
table.
3) To allow the saving/restoration of multiple Relationship Window views.
4) To allow the importing of the layout of the Relationship Window from an
external MDB.

Here is the A97 version:A97Save-Restore-ModifyRelationshipWindow.zip
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Phil Stanton" <ph**@myfamilyname.co.ukwrote in message
news:ht6dnd-urpwjpZzVnZ2dnUVZ8q6onZ2d@plusnet...
Having spent ages sorting out the layout of my relationship window with
about 60 tables and getting it all tidy and with enough of the tables
visible to show the PK an FK relaionshipsOn a subseqent occassion, on
opening the relationship window, I found all the tables had shrunk so that
in most cases, only the table names were visible and the fields could only
be seen by "expanding" the table again.
I know you can print out the relationship window, but can the layout be
saved in any way

Thanks

Phil

Jun 27 '08 #4

P: n/a
As usual, works perfectly

Thanks a million

Phil

"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
wrote in message news:48**********************@news.aliant.net...
Take a look at:
http://www.lebans.com/saverelationshipview.htm

NEW - Feb 04/2004 A2KSave-Restore-ModifyRelationshipWindow.zip is an MDB
containing functions to:

1) To allow the saving of the layout of the Relationship window to a
table.
2) To allow the restoration of the layout of the Relationship Window from
a table.
3) To allow the saving/restoration of multiple Relationship Window views.
4) To allow the importing of the layout of the Relationship Window from an
external MDB.

Here is the A97 version:A97Save-Restore-ModifyRelationshipWindow.zip
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"Phil Stanton" <ph**@myfamilyname.co.ukwrote in message
news:ht6dnd-urpwjpZzVnZ2dnUVZ8q6onZ2d@plusnet...
>Having spent ages sorting out the layout of my relationship window with
about 60 tables and getting it all tidy and with enough of the tables
visible to show the PK an FK relaionshipsOn a subseqent occassion, on
opening the relationship window, I found all the tables had shrunk so
that
in most cases, only the table names were visible and the fields could
only
be seen by "expanding" the table again.
I know you can print out the relationship window, but can the layout be
saved in any way

Thanks

Phil


Jun 27 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.