Relationships Problem / Error.

[MMbosman]

I'm using Access 2000 in a front end, back end situation. My problem is this.
I set up my relationships in the back end and then they disappeared. If I try
to set them up again I get the error "The cascading options for the new
reference conflict with the existing reference." What does this mean? How did
it happen, and how can I fix it?

 

[Allen Browne]

Probably another Name AutoCorrect bug. Uncheck the boxes under:
Tools | General | Name AutoCorrect
and then compact the database.
Do this for both the front end and the back end.

For an explanation of how this misfeature corrupts your database and a list
of the problems it creates, see:
http://members.iinet.net.au/~allenbrowne/bug-03.html
Basically, it tries to track changes in field names. When it stuffs that up,
it can no longer identify which fields are related to which other fields.

If is is too badly corrupted to be fixed by the above, try the 6 steps under
the first symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

During that import processs, you can click the Options button in the Import
dialog to say NOT to import the relationships. That should solve any really
persistent issues, or if you are desperate you can programmatically delete
all the relationships in your database with this code:
http://members.iinet.net.au/~allenbrowne/DelRel.html