#error in memo field

[gwag17]

I have found several #errors in a memo field in one of my tables. Whenever I select the corrupted record it gives me the following message "The Microsoft Jet Engine stopped the process because you and another user are attempting to change the same data at the same time."
Is there any way to fix these records? and does anybody know how this error happens?
I have tried the following code to try and fix it - "IIF(iserror[fieldname]) = true, null,[fieldname])
This however has not worked.
Any help on this would be much appreciated
Alan Jamieson

 

[Len Boorman]

Sounds like you do not have any record locking in place when editing records. What appears to have happened is exactly what is says. Two people editing record at same time.

Have experienced this before.

Solution is to create another table that is exactly the same as the table with corrupted records. Then use an append query to add all records except those with the error.

Delete if possible corrupt table and rename new table to original name.

Cannot remember if you will be able to delete corrupt table.

If not then import all objects except corrupt table to new database and then do the renaming

You do need to address problem of updates

Len B

 

[WayneRyan]

Alan,

Is it possible that you have the memo field present on your
main form (or its data source) and then are trying to bring
up a pop-up form to edit the memo field.

If that's the case, both forms can't have the same data
available for editing at the same time.

Wayne