#Error in field

S

SG

I have one field in one of the many entries in my table that has #Error.
When I go into the field a popup comes up with "more than one person has
tried to enter at the same time". I have tried to delete the record and
cannot as soon as I click on the field the popup comes up. How can I delete
this record ?
 
A

Allen Browne

First, check if this is just a bad locking message.
Close the database.
Look in the folder where this database is stored.
If you see a small ldb file with the same name as your mdb database, delete
it. The ldb (typically 1kb) contains locking information, and can be left
over if Access does not terminate normally.

If that does not solve the problem, you can get Access to recreate the table
without the bad record. Follow the steps for the 3rd symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
Top