Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to obtain an Access database schema?

Discussion in 'Information Technology' started by Jeffery Tyree, Nov 3, 2005.

  1. Jeffery Tyree

    Jeffery Tyree
    Expand Collapse
    Guest

    I have just been handed an Access switchboard application to support with no
    documentation. My experience with Access is minimal. What is the best
    method to print out a copy of the database schema? I see how to view the
    information within Access but I don't see a way of printing it out. Is this
    even possible within Access or should I use external tools; Visual Studio
    Server Explorer or other?

    TIA,
    -Jeff
     
  2. Loading...

    Similar Threads Forum Date
    Sikh Ebooks Obtained from Across the Internet History of Sikhism Oct 26, 2011
    Sikh Obtains Justice Hard Talk Dec 2, 2008
    Sikh News Sikh Obtains Justice: Court Finds CDCR Discriminated Against Bearded Prison Guard App Breaking News Dec 2, 2008
    Sikh News Punjab farmers told to obtain J-Forms from commission agents (New Kerala) Breaking News Sep 9, 2008
    When The Guru Instructs- Understanding Is Obtained Gurmat Vichaar Jan 31, 2008

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Several solutions:

    1. Graphical view:
    Choose Relationships on the Tools menu.
    In Access 2000 and later, you can then File | Print Relationships.
    (In earlier versions, you had to PrintScreen, and paste into MS Paint.)

    2. Documenter:
    Tools | Analyze | Documenter

    3. Better documentation utilities:
    http://home.bendbroadband.com/conradsystems/accessjunkie/doctable.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Jeffery Tyree" <Jeffery_Tyree@yahoo.com> wrote in message
    news:OPP59UE4FHA.696@TK2MSFTNGP09.phx.gbl...
    >I have just been handed an Access switchboard application to support with
    >no documentation. My experience with Access is minimal. What is the best
    >method to print out a copy of the database schema? I see how to view the
    >information within Access but I don't see a way of printing it out. Is
    >this even possible within Access or should I use external tools; Visual
    >Studio Server Explorer or other?
    >
    > TIA,
    > -Jeff
     
  4. Jeff Conrad

    Jeff Conrad
    Expand Collapse
    Guest

    Allen,

    FYI, MS released an Add-in for 97 that allows printing the relationships
    view:

    ACC97: Print Relationship Wizard Available in Download Center:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;175202

    --
    Jeff Conrad
    Access Junkie - MVP
    http://home.bendbroadband.com/conradsystems/accessjunkie.html
    http://www.access.qbuilt.com/html/articles.html

    "Allen Browne" wrote in message:
    news:u1jCT%23E4FHA.3292@tk2msftngp13.phx.gbl...

    > Several solutions:
    >
    > 1. Graphical view:
    > Choose Relationships on the Tools menu.
    > In Access 2000 and later, you can then File | Print Relationships.
    > (In earlier versions, you had to PrintScreen, and paste into MS Paint.)
    >
    > 2. Documenter:
    > Tools | Analyze | Documenter
    >
    > 3. Better documentation utilities:
    > http://home.bendbroadband.com/conradsystems/accessjunkie/doctable.html
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Jeff Conrad" <jeffc@ernstbrothers.com> wrote:

    >FYI, MS released an Add-in for 97 that allows printing the relationships
    >view:
    >ACC97: Print Relationship Wizard Available in Download Center:
    >http://support.microsoft.com/default.aspx?scid=kb;en-us;175202


    And Lebans created one at my request when I ran out of space on the
    Print Relationship Wizard. Currently at 4' x 3' and requires a
    plotter to print it.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  6. Jeff Conrad

    Jeff Conrad
    Expand Collapse
    Guest

    "Tony Toews" wrote in message:
    news:htdlm15m1a63st0op3fjdlaph21h39hdfq@4ax.com...

    > And Lebans created one at my request when I ran out of space on the
    > Print Relationship Wizard. Currently at 4' x 3' and requires a
    > plotter to print it.


    I remember you mentioning this when we were at the Summit, but
    I did not realize Stephen had made something special for you.
    Nice to have friends like that!
    :)
    --
    Jeff Conrad
    Access Junkie - MVP
    http://home.bendbroadband.com/conradsystems/accessjunkie.html
    http://www.access.qbuilt.com/html/articles.html
     
  7. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Jeff Conrad" <jeffc@ernstbrothers.com> wrote:

    >> And Lebans created one at my request when I ran out of space on the
    >> Print Relationship Wizard. Currently at 4' x 3' and requires a
    >> plotter to print it.

    >
    >I remember you mentioning this when we were at the Summit, but
    >I did not realize Stephen had made something special for you.
    >Nice to have friends like that!
    >:)


    I'm glad I whined too. <smile>

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page