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

  • Thread starter Thread starter Sunita
  • Start date Start date
S

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
 
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
Click to expand...

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.
 
Back
Top