Error 3218 - Could not update; currently locked

[Montez659]

I recently built a db and it has been in use at my company for a couple of months now, but something new just cropped up - Error 3218, Could not update, currently locked.

I have combed the internets en masse only to find too many different reasons why this is happening. The one thing that I know is that this may possibly be the first time that two different users were attempting to add records simultaneously (which is something I thought that they were supposed to be able to do after the db split).

So I come humbly to ask for help in correcting this error. It seems that it stems from Record Locking, but I am not really sure what I would need to change to fix it. I would also ask that you be so kind as to explain the answer to me, and why it works (if you can) instead of just the solution; I am here to learn, not just get a project done!

Thanks to many in advance!

 

[boblarson]

Bob, any thoughts on that link I posted above?

Does your table which the form is based on have any of those items (memo fields, hyperlink fields, OLE Object or Attachment fields)? If so, that is the likely problem according to the article (and Alex and Tom are two that I would trust to know what is happening).

 

[Montez659]

It does have one m-v field but none of the others. The only reason I have it in there is because it was basically for notating purposes and none of the reports were based off of it. I will look into changing it to a junction table or just limiting it to one value.