N
Nelson
Periodically we find a record in a table that has #Deleted in all feilds of
the record. It can not be deleted. The database must be compacted and
repaired and then the record can be deleted. This is usually discovered when
a user open a form that uses a query linked to that table and they receive
"Record is deleted" window. The record is not deleted by any users. Seems
to be a false state.
Last occurance - someone indicated they were in the record put in this
state. They used the back space to clear information in the record. That
was only known change to the record.
Looking for a possible root cause.
the record. It can not be deleted. The database must be compacted and
repaired and then the record can be deleted. This is usually discovered when
a user open a form that uses a query linked to that table and they receive
"Record is deleted" window. The record is not deleted by any users. Seems
to be a false state.
Last occurance - someone indicated they were in the record put in this
state. They used the back space to clear information in the record. That
was only known change to the record.
Looking for a possible root cause.