Hi All

In a 2.6 system which has been up and running for the last 5yrs or so without problem, a "junction" table has suddenly incurred thousands of deleted records where no delete instruction has been issued by the application. I have had to hastily write a tool to RECALL the deleted records when they are discovered after a policyholder's enquiry.

These records point driver(s) to vehicle(s) on single and fleet motor insurance policies. This, as you will imagine is a very serious issue. For all intent and purpose, we query a vehicle record to find there are no drivers! Of course there are, the pointer records in the junction table have been deleted and have to be recalled.

I re-iterate, there is no single programmed scenario that would delete these records to anything like this scale? If we delete a driver on a policy, the individual pointer record is deleted. However, this is done individually and infrequently. We have suddenly been hit with this plague of deleted records in the last 48 hours.

Is anyone aware of any environmental way that as a result of a system/workstation crash etc., records can be deleted without a DELETE command having been explicitly issued?

Any comments welcomed.

TIA