Table in behaving weirdly

[Middlemarch]

Something unexpected happened and now when I open my table and try to edit a certain field I'm told

Your changes cannot be saved because the field 'fName' has been updated by another user.

There's no other user. I've restarted Access but no change. The field contains "#Deleted" which I did not put there.
The rest of the record looks ok, and can be edited just this field is having a hissy fit.
How might I get it to accept new text ?



If I try to copy the whole table, it won't. Tells Me Record is Deleted. Although the record can be seen.

Any idea what's going on ?
Thanks.

[CJ_London]

sounds like corruption. Try compact repair and if that fails try creating a new table and import all records except the deleted ones (exclude on the PK)

INSERT INTO newtable
SELECT * from oldtable
WHERE PK not in (3,6,8...)

[Middlemarch]

Thanks @CJ_London. All sorted.