Relationships don't show

[Guest]

I have a database set up with multiple table that we have been using for
several years. Lately I have noticed that in my relationship window when I
tell it to show all relationships some of my relationships have disappeared.
When I recreate them and tell it to save the changes and then close and then
reopen my changes are gone. Whats happening to them and why are they not
being saved? Help please!

 

[Allen Browne]

This can happen if the database is partially corrupt. For example, if you
rename a table or the fields involved in a relation, and Access is confused
about the names. Name AutoCorrect may be a contributing factor here.

To correct the issue:
1. Create a new (blank) database.

2. Before doing anything else, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.

3. Import the tables from the problem database:
File | Get External | Import
Select all the tables on the first tab of this dialog, but before performing
the import, click the Options button and UNCHECK the box to import
Relationships. This way the broken relations are not imported.

4. After importing the tables, open the Relationships window (Tools menu),
and recreate your relations.

5. Now import the other objects from your problem database:

File | Get External | Import
and select all the queries, forms, reports, etc.

6. Press Ctrl+G to open the Immediate Window.
Choose References from the Tools menu.
Set up the references you had before, or for the minimum ones you need, see:
http://members.iinet.net.au/~allenbrowne/ser-38.html

7. Still in the code window, choose Compile from the Debug menu to make sure
any code can be understood.

 

[Guest]

Thank you Allen, This has fixed my problem. You are a lifesaver.