"I have an Access database that in several records, there is one field that has #Error in it. If I enter the cell with the #Error, I get a message saying
The Microsoft Jet database engine stopped the process because you and another user are attempting to change
the same data at the same time. (Error 3197)
"As soon as I hit OK, the exact same message pops up a second time. This also happens when I try to resize the column with the error in it, except then the message pops up twice for every record that has #Error in it. The same thing happens if I try to copy the data, or try to export it to an external file. I have tried the Repair Database command - Access says it was successfully repaired, but I still have the same problems with the data."
This is what you need to do:
1. Write down the PK of the record that has the #Error.
2. Create a make-table query, filtered for just that one PK, and include all fields except the "bad" field. Run the query to make a temp table with one record.
3. Delete the "bad" record from the original table.
4. Append the record from your temp table back to the original table.