I have a particularly troublesome client who gets intermittent backend crashes leading to a 'Record is Deleted' error message.
The main form shows Client data with Jobs in a subform.
When a crash occurs the backend won't open but recovers after Compact & Repair. Then looking at the Client table, there's always a record with all fields showing ######. Deleting this removes the problem.
In case this was a referential integrity problem I removed the Delete buttons for Clients and Jobs and used new Delete buttons to set flags that then exclude the 'deleted' data from showing in forms and reports.
Even so there have been a few new instances of the error. Any thoughts as to what else can be done to prevent them.
The main form shows Client data with Jobs in a subform.
When a crash occurs the backend won't open but recovers after Compact & Repair. Then looking at the Client table, there's always a record with all fields showing ######. Deleting this removes the problem.
In case this was a referential integrity problem I removed the Delete buttons for Clients and Jobs and used new Delete buttons to set flags that then exclude the 'deleted' data from showing in forms and reports.
Even so there have been a few new instances of the error. Any thoughts as to what else can be done to prevent them.
