Table Relationships

K

Kenneth H. Young

I have been experiencing problems with an Access databases
Relationships. On occasions I will be notified that a record is missing.
On review I will find a record with crazy characters in it and will have to
delete the record. On examination of the Relationships everything appears
OK, but after a compact/repair is run all of the relationships will be gone
and then I have to rebuild them. Any clue as to what might cause this to
happen?



Thank you,
 
A

Allen Browne

The symptoms indicate a corrupt index.
Access finds and deletes the index when you perform the repair.
If the relationship was based on the index, you have to recreate the
relation also.

Like most databases, Access holds the indexes in RAM and only writes them
periodically. If the power is interrupted before the index is written, the
database is then in an inconsistent state. To prevent the problem, you are
looking for what causes the interrupted write. For details, see:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html
 
Top