Receive error "Record is deleted" when opening table
Posted on 2011-02-14
I have been asked to look at an Access 2003 database I did not create. The problem is an error, "Record is deleted", appears when I try to open the table. This is a recurring problem with a database that about 30 people use at the same time. It also has about 180 fields in this table.
After researching I have found that this can happen when two people have the same record open and one changes or deletes the record then closes the database before the other. The fix is to Compact and Repair, which I have done. I can then open the table. Tthe first record has multiple # signs in many, but not all, of the fields. I checked and the Edited Records property is set to No Locks. Would changing this property to Edited Record fix the problem or could there be something else that is wrong and needs to be done? Your help is greatly apprecaited.