Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    May 2002
    Location
    Alabama, U.S.
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing table structure (Access 97)

    I seem to remember a post some time ago where someone mentioned a utility you could use to print out the structure of your tables. Is anyone familiar with a tool that will do this? Any suggestions will be greatly appreciated.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Printing table structure (Access 97)

    Access 97 has a basic documentation capability, but it doesn't print out a graphical representation of your table structure. In Access 2000, you can effectively print out the ER diagram, but to really get the soup to nuts view, you need something like the FMS Analyzer product, which isn't cheap.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Printing table structure (Access 97)

    Try Tools-->Analyze-->Documenter. That will allow you to print out information about the fields, indexes, etc., on your tables. If you have money to burn, http://www.fmsinc.com has several tools that print out more information than you ever wanted to know about your tables, and if you want a graphical representation, Microsoft Visio can reverse engineer a database schema and create a diagram of your tables and relationships. However, none of the apps like Visio or the much less expensive DeZign for Databases, are easy to use for this purpose and they don't use the Access datatypes in their diagrams. If you just want to print the relationships window, there was an add-in you could download for A97 that created a report resembling the relationships layout, but it didn't work very well.
    Charlotte

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Printing table structure (Access 97)

    Mark Liquorman (one of the moderators of this forum) has created a free utility that produces documentation in a standard Access report. You can download it from his website http://www.liquorman.net - look for Tips, links and downloads.

  5. #5
    New Lounger
    Join Date
    May 2002
    Location
    Alabama, U.S.
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing table structure (Access 97)

    Thanks to everyone that replied to my request. While I was waiting for a response I dug around some more in the Help files and found the Documenter in Access which provided the info I needed.

    Again, thanks for the help.

    Rick

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing table structure (Access 97)

    <P ID="edit" class=small>(Edited by charlotte on 20-Nov-02 19:38. to activate link)</P>Hi Rick

    Go the http://www.RogersAccessLibrary.com

    Look in other develpoers code tab.

    I can't remember which one, but one of them has Oracalize_Table_Fields.mdb that has some interesting code and routine to print simple data structure to a text file.

    HTH

    John

  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Printing table structure (Access 97)

    RBW,
    for what it still is worth... Tony d'Ambra's FreeAccess site offers a free utility which draws out the table structure 'designed' in the relationships window to a printable & more-a-less editable report. http://www.aadconsulting.cjb.net/vizrel.html
    He has a Documenter alternative too (.../ezydoc.html), which just documents the important information on your objects - often preferable to what Access provides.
    Hans

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •