Link to home
Start Free TrialLog in
Avatar of LSE_IT_Training
LSE_IT_Training

asked on

Tables located beyone the scrollable/visible area in the Relationships Window

I've developed an Access d/base with about 50 tables.  Somehow 1 of these managed to locate itself above the visible area of the Relationships Window; the scrollbar doesn't go there.  In fact the only way I know it exists is because relationships exist between it and other visible tables.  I've tried deleting the relationships and creating a 2nd copy of the table in the window, then reconnecting relationships to the visible version, but despite saving these, the next time I open the window the relationships are again linked to the invisible table.  To make matters worse, another table has now jumped up to join the first one.  Why does this happen, how can I fix it and prevent others from moving out of visible bounds?
Avatar of GRayL
GRayL
Flag of Canada image

Is any of the table window visible or is just the thick blue top line at the top invisible?
Try maximizing the Relationships window?
ASKER CERTIFIED SOLUTION
Avatar of Rick_Rickards
Rick_Rickards
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, Rick - that's one to bookmark!
You're most welcome.  I actually provided a poster to Microsoft illustrating this very bug back in 2005.  They hung it on the wall and put a note below the poster (huge screen shot of the relationships window as the database had over 100 tables in it) saying something to the effect... "Herein lies a bug, Can you see it?"  Nothing like a little brain teaser for the testers who were working on Office 2007 at the time.

Rick
Avatar of LSE_IT_Training
LSE_IT_Training

ASKER

Hey Rick, its not for nothing you are a 'guru'!  Many thanks - option 2 worked a treat!  In answer to the version question, I am using Access 2003 sp3, working on a d/b in Access 2000 file format.  Many thanks again.  How DO you keep track of such obscure problems and their solutions??!!
I wish the asker appreciated it as much as I;-)
Rick, this is a second attempt to post a giant 'thank you' for your brilliant solution to my question.  Option 2 worked a treat - its not for nothing you are a 'guru'!   How DO you manage to keep track of such apparently obscure issues?  In answer to your question, I am running Access 2003 sp3 to work on a d/b in Access 2000 file format.
My first 'thank you' message seems to have disappeared into the ether when I accepted your solution.  Did the points you so deserve disappear as well?  Please advise if there is something I can do to redirect them back to you!  As the question disappeared off my 'Questions in Progress' list, I assumed that both my message and the points had gone to their intended destinations until I checked my latest messages.    
It would appear that LSE_IT_Training quitely extended appreciation by awarding points and then verbosely did in the last post.  By the way LSE_IT_Training, you are again most welcome.

In answer to LSE_IT_Training's questions:
Q: How DO you manage to keep track of such apparently obscure issues?
A: Not sure except to say I feel fortunate, (or unfortunate depending on the memory), to have a memory that seems unwilling to forget things easily.  Even when I cease to rely or use the information and despite the fact that decade’s may pass the memory remains crystal clear as if memorized it moments ago.

Q: Did I get the points
A: Yes I did, all 2000.  Thanks once more.

Thanks again GRayL for the compliment.