C
chrisp
Guest
Noticed random records were missing from database. Checked all tables, checked field properties and relationships which seemed okay except data appeared as follows:
Table 1 - random records were missing (approximately 1000 of 3000 records). Primary Key of table 1 is foreign key in tables 2, 3, 4 with relationships as 'one to many'.
Random records are also missing from Tables 2, 3, & 4 although in some instances, they weren't the same related record. i.e. record missing in table 1 appeared in table 2 etc.
There doesn't seem to be a pattern for the missing data as most of the records are perfect. We also were not able to establish when the corruption might have happened because records missing range from 1999 to 2004.
Has anyone heard of such a problem? What could have caused it and can it be fixed? Please help!
Table 1 - random records were missing (approximately 1000 of 3000 records). Primary Key of table 1 is foreign key in tables 2, 3, 4 with relationships as 'one to many'.
Random records are also missing from Tables 2, 3, & 4 although in some instances, they weren't the same related record. i.e. record missing in table 1 appeared in table 2 etc.
There doesn't seem to be a pattern for the missing data as most of the records are perfect. We also were not able to establish when the corruption might have happened because records missing range from 1999 to 2004.
Has anyone heard of such a problem? What could have caused it and can it be fixed? Please help!