record loss in table

[terzak]

Twice in the last week one table has been cleared of records. Once I could
not repair and restored from tape. The second time I could compress and
repair, but the records that had been modified were gone or rolled back. I
am at a loss of where to start looking.

Terry

 

[Allen Browne]

*All* the records were deleted from the table?

That sounds like some process is at work, such as:
- a delete query
- a cascading delete relationship
- code/macro clearing records from the wrong table
- a malicious or ignorant user doing damage.

It is possible for an index to go bad so that records some disappear (even
though they are still in the table):
http://allenbrowne.com/ser-47.html#NumberOfRecordsVaries

If that does not describe your case and the database really is going corrupt
on a regular basis while only the data is being changed (i.e. not while you
are modifying the form and report design or code), you would be starting to
look for anything that could interrupt a disk write. Suggestions for
preventing corruption:
http://allenbrowne.com/ser-25.html