?
Solved

Missing Relatioships

Posted on 2011-10-03
7
Medium Priority
?
245 Views
Last Modified: 2012-05-12
Experts,
Suddenly I am only able to see some of my relationships in the relationship window and was wondering what happened.
0
Comment
Question by:Frank Freese
  • 5
  • 2
7 Comments
 
LVL 58
ID: 36905467

 The layout in the relationship window is seperate from the relationships themselves.  Click on view, then show all tables.  

 If you still don't see the tables, look for scroll bars.  You may have to scroll to see the layout.

Jim.
0
 

Author Comment

by:Frank Freese
ID: 36905519
scroll bars aren't a problem - view had no affect
0
 

Author Comment

by:Frank Freese
ID: 36905547
when I go to print preview everything is OK
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 36905556

 Well then sounds like you don't have any.   You are in the right DB correct (not possibly working in a copy)?

 If so, then you may have some DB corruption.  I've never known relationships to simply disappear.  I would create a new blank DB, import everything into it and see if their back.  Make sure to click the options button and check the relationships box.

Jim.
0
 

Author Comment

by:Frank Freese
ID: 36905560
let me give this a try
0
 

Author Comment

by:Frank Freese
ID: 36905605
exported to new db - ok....some corrpution in the old one - thank
0
 

Author Closing Comment

by:Frank Freese
ID: 36905609
thank you
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question