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

Re: Preserving Relationship window

On Apr 12, 6:33 pm, "Phil Stanton" wrote:
> 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.

Re: Preserving Relationship window

lyle wrote in
news:2a05cb60-d59d-4ec2-978d-9f741e037d31@f63g2000hsf.google groups.com:

> On Apr 12, 6:33 pm, "Phil Stanton" wrote:
>> 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.

Re: Preserving Relationship window

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" wrote 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
>

Re: Preserving Relationship window

As usual, works perfectly

Thanks a million

Phil

"Stephen Lebans"
wrote in message news:48019aed$0$4041$9a566e8b@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" wrote 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
>>
>
>