How do I add the Database Diagrams button to the Database window?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FWoodson - 27 Feb 2007 03:07 GMT

I was trying to intiate many to many relationships with tables in a database
but when trying to follow the instructions on how to do that in Help, the
instructions read that I should select Database Diagrams under Objects in the
Database indow. There is no Database Diagrams button to press under Objects
in the Database window. Why would it be missing? How do I get it to display?

Reply to this Message

Damian S - 27 Feb 2007 03:21 GMT

The database diagram button is the one on the main toolbar that looks like
three forms joined with lines. (In Access 2003 and previous).

Damian.

> I was trying to intiate many to many relationships with tables in a database
> but when trying to follow the instructions on how to do that in Help, the
> instructions read that I should select Database Diagrams under Objects in the
> Database indow. There is no Database Diagrams button to press under Objects
> in the Database window. Why would it be missing? How do I get it to display?

Reply to this Message

Van T. Dinh - 27 Feb 2007 05:42 GMT

In Access 2003 and earlier, you can use the Menu Command Tools /
Relationship ... to open the Database Diagram / Relationship window ...

Signature

HTH
Van T. Dinh
MVP (Access)

>I was trying to intiate many to many relationships with tables in a
>database
[quoted text clipped - 5 lines]
> in the Database window. Why would it be missing? How do I get it to
> display?

Reply to this Message

Brendan Reynolds - 27 Feb 2007 18:59 GMT

Database Diagrams are a SQL Server feature and are only available in Access
when using an ADP front-end, so one possible reason why you are not seeing
them is that you may be using an MDB?

The closest equivalent in an MDB is the Relationships window.

Signature

Brendan Reynolds
Access MVP

>I was trying to intiate many to many relationships with tables in a
>database
[quoted text clipped - 5 lines]
> in the Database window. Why would it be missing? How do I get it to
> display?

Reply to this Message