3188 Currently Locked error message when updating memo field

[whp963]

I have a memo field that contains over 2000 characters. When I try to clear
that field with an Update table set table.field = '' string, I get a 3188
error, cannot update, currently locked. I'm the only one using the database,
so no one else has it locked. And if the memo field contains less than 2000
characters, I don't get an error. I need a work-around.

 

[John W. Vinson]

I have a memo field that contains over 2000 characters. When I try to clear
that field with an Update table set table.field = '' string, I get a 3188
error, cannot update, currently locked. I'm the only one using the database,
so no one else has it locked. And if the memo field contains less than 2000
characters, I don't get an error. I need a work-around.

Are you trying to run an update query on the table, while you simultaneously
have the record open for editing on the form? If so that's the conflict.
Perhaps you could post your code with a bit more explanation of the context!

 

[Dave C]

Bumping this question, because I'm running into the same thing. Everything
works perfectly until the memo field hits a certain size, then the 3188
starts on an UPDATE call.