Preserving Relationship window

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

    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


    Tags: None
    • lyle
      #2
      Re: Preserving Relationship window

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

        Comment

        • lyle fairfield
          #3
          Re: Preserving Relationship window

          lyle <lyle.fairfield @gmail.comwrote in
          news:2a05cb60-d59d-4ec2-978d-9f741e037d31@f6 3g2000hsf.googl egroups.com:
          On Apr 12, 6:33 pm, "Phil Stanton" <p...@myfamilyn ame.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.

            Comment

            • Stephen Lebans
              #4
              Re: Preserving Relationship window

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


              NEW - Feb 04/2004 A2KSave-Restore-ModifyRelations hipWindow.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-ModifyRelations hipWindow.zip
              --

              HTH
              Stephen Lebans
              Lebans.com
              http://www.lebans.com

              Access Code, Tips and Tricks
              Please respond only to the newsgroups so everyone can benefit.



              "Phil Stanton" <phil@myfamilyn ame.co.ukwrote in message
              news:ht6dnd-urpwjpZzVnZ2dnU VZ8q6onZ2d@plus net...
              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
              >

                Comment

                • Phil Stanton
                  #5
                  Re: Preserving Relationship window

                  As usual, works perfectly

                  Thanks a million

                  Phil

                  "Stephen Lebans" <ForEmailGotoMy .WebSite.-WWWdotlebansdot ...@linvalid.co m>
                  wrote in message news:48019aed$0 $4041$9a566e8b@ news.aliant.net ...
                  Take a look at:
                  SaveRelationshipView
                  http://www.lebans.com/saverelationshipview.htm

                  >
                  NEW - Feb 04/2004 A2KSave-Restore-ModifyRelations hipWindow.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-ModifyRelations hipWindow.zip
                  --
                  >
                  HTH
                  Stephen Lebans
                  Lebans.com
                  http://www.lebans.com

                  Access Code, Tips and Tricks
                  Please respond only to the newsgroups so everyone can benefit.
                  >
                  >
                  >
                  "Phil Stanton" <phil@myfamilyn ame.co.ukwrote in message
                  news:ht6dnd-urpwjpZzVnZ2dnU VZ8q6onZ2d@plus net...
                  >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
                  >>
                  >
                  >

                    Comment

                    Previous template Next
                    Working...