Issues with updated Memp by SQL code. Keep getting Error msg "Could not update; Currently Locked by session on this machine"

[Andrew....@shell.com]

I am trying to update a memo field in a table from a form that I have
created. The form is unbound, and once the user makes their changes,
they have to click the continue button. Once the button is click
then, there is some VB code that uses SQL Update to take the
information on the form and update the table with the new changes.
However, I am having issues with the Memo fields. I have looked at
several different posts and have not been able to come up with a
solution. Can anyone offer any info at all?? The VB error code is
3188.

Cheers

[kevin...@gmail.com]

Is the table opened by you or someone else in design mode?
Do you have "record locks -- All records" selected?

I googled "3188 and access and lock" and found this:

<--->
I am starting to get 'Multi-user' conflict errors by some users when
attempting to enter a record which contains a memo field. I know
that there are no other users logged in. My solution, or a quick
fix, is to copy the memo field to the clipboard (or notepad) cancel
out of the record, then select Add Record again (I use tempoary tables
to add/edit records). This works everytime, but I'm stumped as to
why this error occurs in the first place. Any suggestions please.
<--->

HTH,
KC