By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,847 Members | 2,321 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,847 IT Pros & Developers. It's quick & easy.

Relationships: Table goes AWOL. How do I retrieve it?

P: 4
MY database in Access 2003 is made up of about 30 related tables with relationships defined. I hit the "Show All Relationships" button on the tool bar and one of these tables somehow decided to move outside of the accessible area. The relationship lines are still attached to the appropriate tables but I can no longer see the table no matter what I do with the scroll bars.. The table seems to be in the upper left part of the screen. When I triangulate with the relationship lines, the table seems to be about two inches outside of the monitor. I tried to show that particular table and I get the table with a tablename-1 and no relationshps. The AWOL table remains off the monitor and out of sight.

How do I retrieve it? Why does this happen?
Jun 1 '07 #1
Share this Question
Share on Google+
1 Reply

P: 4
I have one work around. Tab until no other tables are highlighted (that means the table in outer space is highlighted). Then Edit, Delete the table. Then, show table and resize and position as necessary.

Last time this happened, I got rid of the whole relationships display and redid the whole thing. It took quite a bit of work.

I still don't know why this happens?
Jun 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.