Preserving Relationship window

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

On Apr 12, 6:33 pm, "Phil Stanton" <p...@myfamilyname.co.ukwrote:>
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.
>

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
>

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" <phil@myfamilyname.co.ukwrote in message
news:ht6dnd-urpwjpZzVnZ2dnUVZ8q6onZ2d@plusnet...>
>