lost records!

message from Tim on 28 May 2004

I'm working with a database of about 60,000 students and
each have a number of lessons that are stored in a
separate lessons table. This table has about 460,000
records.

Recently, I've found four or five separate instances of a
student's records studenly being gone. Is there a way
Access is somehow deleting these -- because it's too big
of a coincidence for staff to be deleting these records
(they'd have to delete each one individually). Is there a
way I could track down what exactly is happening and
figure out how to prevent this from happening in the
future???

thanks,

Tim

Allen Browne replied to Tim on 28 May 2004

First thing to try would be a compact/repair, in case the problem is caused
by a corrupted index.

Next, check for any records that have a null foreign key. This condition can
arise - even if you enforce referential integrity - unless you set the
foreign key's Required property.

Cascading deletes turned on where it should not be?

Any action queries in the application that could be executed too easily?

Archived message: lost records! (Microsoft Access Error Message)