Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Location
    Bruges, Belgium
    Posts
    122
    Thanks
    14
    Thanked 2 Times in 2 Posts

    Printing Relationships (Access XP)

    I find it useful to have a printed copy of the Data Base RelationShips. When I "print" this window in Access, it offers me a design view of a report that eventually will be printed and saved. I often change the design view to highlight some particulars in the tables. Much to my dismay, unlike normal reports, subsequent changes to the data base tables (e.g. new fields, changed relations) don't show up when re-using the report.
    Is there a way to keep the design of the report, but reflect the changes in the data base design??

    Another source of frustration is the fact that when tables are moved in the report (design view) the connector lines (the one that reflect relations) do not move along.

    Any ideas are most welcome

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

    Re: Printing Relationships (Access XP)

    The report you get is fixed, it is not linked to the database structure dynamically. So you're out of luck. You'll have to create the report anew from scratch, or update it manually.

  3. #3
    Star Lounger
    Join Date
    Aug 2003
    Location
    Brisbane, Queensland, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Relationships (Access XP)

    If you get a chance to get hold of a copy of Microsoft Visio Pro, Fire it up, choose database design model, pick the database menu at the top and chose Reverse Engineer. Then follow the bouncing ball. It will draw BRILLIANT E-R diagrams of your database.

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

    Re: Printing Relationships (Access XP)

    However, it requires a fair amount of work to layout the relationships clearly and legibly in Visio. It's a wonderful tool, but it is not painless to learn.
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Aug 2003
    Location
    Brisbane, Queensland, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Relationships (Access XP)

    You are right, but the final product sure beats the heck out of what you get from the relationships window in Access - especially connectors that don't have to be straight and information on indexes and foreign keys.

Posting Permissions

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