Deleted record in a table is displayed and still exists with "#Deleted" in all cols.

[Sunita]

Hi All,

I have this table with deleted record which has a "#Deleted" written
in all cols. I tried to delete this record, it gives me an
confirmation about record deleted, but it does not delete this record.

Since this table has an entry of "#Deleted", all queries running
against it fail, with an error message "Record Deleted" ..

Has anybody come across this kind of problem and is there a way to fix
this?

Thanks for helping,
Sunita

 

[John Vinson]

Hi All,

I have this table with deleted record which has a "#Deleted" written
in all cols. I tried to delete this record, it gives me an
confirmation about record deleted, but it does not delete this record.

Since this table has an entry of "#Deleted", all queries running
against it fail, with an error message "Record Deleted" ..

Has anybody come across this kind of problem and is there a way to fix
this?

Thanks for helping,
Sunita

Normally this appears only when the table is a linked table in a
product other than Microsoft Access - is it a dBase, or SQL, or ORACLE
table?

Try Requerying: hit the F9 key to refresh your view of the data.