Vanishing Relationship

[PurpleUnicorn]

I have a database with a table "PART" that is related (referential integrity enforced and set to cascade updates) to 3 other detail tables. The primary key of PART consists of multiple fields.

The client just noticed that some changes he made to the primary table did not update in the related tables. When I looked at their data, I found that 2 of the relationships no longer existed.

How is it possible for relationships to disappear? The client is certain that nobody manually removed them.

Thanks!

 

[KornGeek]

I have seen relationships disappear by users deleting (and then restoring) tables. However, Access asks you to confirm you want to remove the relationship before doing this. From my experience, you are likely to either have a malicious or utterly clueless user tinkering around where they shouldn't be. (In my experience, sadly enough, it's usually the clueless variety.) Sleep is for people with no caffeine.