Relationship not showing up in relationship view

[Bob]

I am having the exact same problem and none of the
solutions seem to work. Suggested code for deleting
relationships shows a compile error. Hard to believe this
problem is happening in an established product like
Access. If anyone finds a solution please let me know.
Have to redefine the DB due to this.

 

[Allen Browne]

If the code will not compile, you probably need to add a reference to the
DAO library.

1. Open the code window.
2. Choose References on the Tools menu.
3. Check the box beside:
Microsoft DAO 3.6 Library.

More information:
http://members.iinet.net.au/~allenbrowne/ser-38.html

I have not personally seen this problem for 7 years, but we always make sure
that Name AutoCorrect is turned off. It would be the primary suspect for
this corruption. More reasons why it should be turned off:
http://members.iinet.net.au/~allenbrowne/bug-03.html