Access Relationship view problem

Since my upgrade to Windows 10 and Office 2016, I have had a problem with the relationship view in Access. Nearly all my relationship tables were clustered over each other at the top of page, and I was unable to scroll upward to view them. I tried to find a solution many times, but got stuck in not finding a solution, and pretty much gave up. I didn't need a solution badly enough to push through.

Then I needed to change the character value of a primary key which was linked to other tables, and HAD to be able to view the relationships so I could remove the relationships in order to make that change (and then to reinstate them once the change was made).

If only I had pushed on earlier. The fix was surprisingly easy, using two Access functions which I had never previously used. All I needed to do was to click the "Clear Layout" button in the Relationship view. All my database relationships disappear (at this point I was mentally shrieking "Eeeeeek!". Then I simply had to click the "All Relationships button. This put all the database relationships back in a stacked order. It is not well organised, but it is visible.

Yay!


Sam

• Reference: Cano, L. (9 December 2015). Access 2016 relationship window, how to resize. Retrieved from https://answers.microsoft.com/en-us/msoffice/forum/all/access-2016-relationship-window-how-to-resize/2bdfef01-80c6-49ed-95ed-94c6f65f4a17