data diagram

I need to diagram relationships in a database that I inherited from another
user so I can figure out how it works. I'm new to Access. Both in Help and in
the Access book I have (Access 2003 Inside and Out) they describe Database
Diagrams. It looks like there should be a "Database Diagrams" selection under
Objects in the database window. I don't have a "Database Diagrams" option to
select. I can't find "Database Diagrams" in any of the menus. I'm using
Access 2003.

What am I missing here?

I also tried using the Relationships icon -- I add queries and tables to
that view but can never get any of the relationship links to display.

Thanks,
Rob

Check the Relationships toolbar button.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"br549" wrote in message
...
I need to diagram relationships in a database that I inherited from another
user so I can figure out how it works. I'm new to Access. Both in Help and
in
the Access book I have (Access 2003 Inside and Out) they describe Database
Diagrams. It looks like there should be a "Database Diagrams" selection
under
Objects in the database window. I don't have a "Database Diagrams" option
to
select. I can't find "Database Diagrams" in any of the menus. I'm using
Access 2003.

What am I missing here?

I also tried using the Relationships icon -- I add queries and tables to
that view but can never get any of the relationship links to display.

Thanks,
Rob

Hey,

The relationships window, opened by toolsrelationships or the relationships
icon on the toolbar, is where relationships are created, destroyed and
viewed.

If you have opened the relationships window and there is nothing there then
I
would guess that there are no relationships established.

Adding tables to the relationship window will not establish or display a
relationship that has not been previously created.

Without knowing your table structure it would be impossible to guess at what
the relationships might be.

Sometimes Access will automatically display relationships when you create a
query.

Try making a new query and add a couple of tables to it and see if there are
any relationship lines displayed.

Mike


"br549" wrote in message
...
I need to diagram relationships in a database that I inherited from
another
user so I can figure out how it works. I'm new to Access. Both in Help and
in
the Access book I have (Access 2003 Inside and Out) they describe Database
Diagrams. It looks like there should be a "Database Diagrams" selection
under
Objects in the database window. I don't have a "Database Diagrams" option
to
select. I can't find "Database Diagrams" in any of the menus. I'm using
Access 2003.

What am I missing here?

I also tried using the Relationships icon -- I add queries and tables to
that view but can never get any of the relationship links to display.

Thanks,
Rob

OOPS,
With the relationships window open click the "show relationships" button on
the toolbar.

Mike


"br549" wrote in message
...
I need to diagram relationships in a database that I inherited from
another
user so I can figure out how it works. I'm new to Access. Both in Help and
in
the Access book I have (Access 2003 Inside and Out) they describe Database
Diagrams. It looks like there should be a "Database Diagrams" selection
under
Objects in the database window. I don't have a "Database Diagrams" option
to
select. I can't find "Database Diagrams" in any of the menus. I'm using
Access 2003.

What am I missing here?

I also tried using the Relationships icon -- I add queries and tables to
that view but can never get any of the relationship links to display.

Thanks,
Rob

Maybe I'm not understanding "relationships". When I open the design view of
a query I see several tablesand queries in the upper pane with lines
connecting different fields. I thought the lines connecting the
tables/queries were the relationships.

This database is incredibly complicated, more than 20 tables/queries. There
are so many different links, select queries, crosstab queries, etc that I'm
finding it very difficult to understand the structure of the whole thing. If
I could even just print out what I see in Design View it would help, but
there don't seem to be any print options when I'm in that view.

"Mike Revis" wrote:

Hey,

The relationships window, opened by toolsrelationships or the relationships
icon on the toolbar, is where relationships are created, destroyed and
viewed.

If you have opened the relationships window and there is nothing there then
I
would guess that there are no relationships established.

Adding tables to the relationship window will not establish or display a
relationship that has not been previously created.

Without knowing your table structure it would be impossible to guess at what
the relationships might be.

Sometimes Access will automatically display relationships when you create a
query.

Try making a new query and add a couple of tables to it and see if there are
any relationship lines displayed.

Mike


"br549" wrote in message
...
I need to diagram relationships in a database that I inherited from
another
user so I can figure out how it works. I'm new to Access. Both in Help and
in
the Access book I have (Access 2003 Inside and Out) they describe Database
Diagrams. It looks like there should be a "Database Diagrams" selection
under
Objects in the database window. I don't have a "Database Diagrams" option
to
select. I can't find "Database Diagrams" in any of the menus. I'm using
Access 2003.

What am I missing here?

I also tried using the Relationships icon -- I add queries and tables to
that view but can never get any of the relationship links to display.

Thanks,
Rob

br549 wrote:
Maybe I'm not understanding "relationships". When I open the design
view of a query I see several tablesand queries in the upper pane
with lines connecting different fields. I thought the lines
connecting the tables/queries were the relationships. [snip]

Nope those are just "Join lines" used by that specific query. Usually these
coincide with relationships between the tables on those same fields but that is
not a requirement and the creation of joins in queries do not "create"
relationships between the tables.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

From the database window select toolsanalyzedocumentercurrent
databaserelationships.

This will give you a printable report of all the relationships in the db.

Mike

"br549" wrote in message
...
Maybe I'm not understanding "relationships". When I open the design view
of
a query I see several tablesand queries in the upper pane with lines
connecting different fields. I thought the lines connecting the
tables/queries were the relationships.

This database is incredibly complicated, more than 20 tables/queries.
There
are so many different links, select queries, crosstab queries, etc that
I'm
finding it very difficult to understand the structure of the whole thing.
If
I could even just print out what I see in Design View it would help, but
there don't seem to be any print options when I'm in that view.

"Mike Revis" wrote:

Hey,

The relationships window, opened by toolsrelationships or the
relationships
icon on the toolbar, is where relationships are created, destroyed and
viewed.

If you have opened the relationships window and there is nothing there
then
I
would guess that there are no relationships established.

Adding tables to the relationship window will not establish or display a
relationship that has not been previously created.

Without knowing your table structure it would be impossible to guess at
what
the relationships might be.

Sometimes Access will automatically display relationships when you
create a
query.

Try making a new query and add a couple of tables to it and see if there
are
any relationship lines displayed.

Mike


"br549" wrote in message
...
I need to diagram relationships in a database that I inherited from
another
user so I can figure out how it works. I'm new to Access. Both in Help
and
in
the Access book I have (Access 2003 Inside and Out) they describe
Database
Diagrams. It looks like there should be a "Database Diagrams"
selection
under
Objects in the database window. I don't have a "Database Diagrams"
option
to
select. I can't find "Database Diagrams" in any of the menus. I'm
using
Access 2003.

What am I missing here?

I also tried using the Relationships icon -- I add queries and tables
to
that view but can never get any of the relationship links to display.

Thanks,
Rob