lost records!

T

Tim

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
 
A

Allen Browne

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?
 
Top