Searching for Tables in the Relationship View

R

Robert

We have a rather large Access Database. There are approximately 300 tables.
It is rather difficult to find a specific table when viewing them in the
Relationship window. Is there an Access function that will aid searches in
the Relationship view?
 
J

John Vinson

We have a rather large Access Database. There are approximately 300 tables.
It is rather difficult to find a specific table when viewing them in the
Relationship window. Is there an Access function that will aid searches in
the Relationship view?
Click to expand...

The relationships window is infuriatingly inflexible and buggy.

I'll often just open the window; click the <X> icon to remove all the
tables (just clears the display, doesn't affect any relationships!);
add the table I'm interested in investigating; and click the Show
Direct button to show only the tables directly linked to the target
table. Just remember to close the window WITHOUT saving!

Access Project .adp files have a *much* nicer setup; you can have
multiple relationship windows for portions of the project, and they're
easier to lay out and seem to be more stable. Wish they'd adapt the
technology to the JET relationship window!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
R

Robert

thank you John; valuable workaround.

John Vinson said:
The relationships window is infuriatingly inflexible and buggy.

I'll often just open the window; click the <X> icon to remove all the
tables (just clears the display, doesn't affect any relationships!);
add the table I'm interested in investigating; and click the Show
Direct button to show only the tables directly linked to the target
table. Just remember to close the window WITHOUT saving!

Access Project .adp files have a *much* nicer setup; you can have
multiple relationship windows for portions of the project, and they're
easier to lay out and seem to be more stable. Wish they'd adapt the
technology to the JET relationship window!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Top