Annoying problems in relationships view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Access Novice - 15 Jan 2005 15:59 GMT

Many times when I create relations between tables, and saves it, when I
reopen the relationships view, everything there is messed up.

Sometimes tables are even "run" outside the screen edges. I can only see the
relation line, and can't reach those tables.

Questions:
1. How can I prevent this to happen.
2. On existing relationships, when tables "run" outside the screen edge, how
can I return those table into the screen boundaries again?

Thanks.

P.S I hope I am asking in the right forum.

Reply to this Message

John Vinson - 15 Jan 2005 21:26 GMT

>Many times when I create relations between tables, and saves it, when I
>reopen the relationships view, everything there is messed up.
[quoted text clipped - 10 lines]
>
>P.S I hope I am asking in the right forum.

The Relationships window has always, IME, been perplexing, annoying,
and unreliable (back to Access 2.0). I wish I had some suggestions
(other than using third-party tools such as Total Access Analyzer from
http://www.fmsinc.com or moving the database to an ADP, which has a
much more powerful Diagrams object); but AFAIK there isn't a foolproof
alternative.

When a table moves offscreen, the best solution is to select a table
which is onscreen; remove your hand firmly from the mouse; press the
<Tab> key on the keyboard until the missing table is selected (i.e. no
visible table is selected; press the <Delete> key to delete it from
the display (this won't hurt any relationships); and re-add the table.

John W. Vinson[MVP]

Reply to this Message