Access Database

D

Donman

I have been noticing existing records are being deleted. The record shows in
a colums the following "#deleted". This shows up in all columns. I try to
delete the record it goes away but when I open the database again the record
comes back. Does anyone know why this is happening and how do I correct the
problem. This is a multi-user database so I do not know how the corrupted
info is being added to the table.
 
M

[MVP] S.Clark

If you open a table and view a record, and someone else deletes that record,
then access will change the record to #Deleted to show you that the record
no longer exists. You can't delete the record at that point, because it's
not there. If you refresh the data, it will be removed from the dataset.
 
Top