Annoying problems in relationships view

A

Access Novice

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.
 
J

John Vinson

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.

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top