Best way to produce visual database diagram?

[RSW]

I put together a fairly complicated database, and I'd like a visual representation of it to use to help explain it to others.

The standard query design view, with tables connected by the joined fields, would be a nice way to show it...but trying to print that out seems like it would be a real chore, with screenshots and cutting and pasting, etc. The relationships take up a lot more than a screenful.

I tried the process I found in Access Help called, "Document and Print your Database Design"...but that produced an 869 page (!!!) report that still doesn't really contain what I want.

I'm curious to find out how others here have generated database diagrams??

 

[Mr. B]

I use the Relationship window from Access. If you have a large number of tables, you may still need to use a screen capture utility and the create a graphic using more than one screen capture, but you get a much better view capability from the Relationship window.

 

[RSW]

I use the Relationship window from Access. If you have a large number of tables, you may still need to use a screen capture utility and the create a graphic using more than one screen capture, but you get a much better view capability from the Relationship window.

Thanks Mr. B,

Yeah, that's what I'm trying now. I guess I thought this might be so common that there'd be some better way to do it, though. I'm taping printouts together as we speak

 

[MarkK]

Who are you documenting for? Do your users understand table relationships enough that your diagrams will make a difference in how they use the system? And for people with the experience to understand your diagram: Can't they just open your database and look around?
For me, and for for a custom 'one-off' system, it seems the high cost and low payoff make it hard to justify the production of significant documentation.

 

[georgedwilkinson]

Oracle Designer (top of the line but has been replaced with a newer product).

ErWin (Meh, it's OK). Visio (sucks). Dia (sucks). Dezign (dunno). More than you'll ever want to know: http://www.databaseanswers.org/modelling_tools.htm

And yes, it is common and necessary for large projects with multiple project members.

 

[RSW]

Thanks, George. I had a look around that website, and it seems like there's a lot of helpful information!