467,117 Members | 1,164 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,117 developers. It's quick & easy.

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

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
Nov 13 '05 #1
  • viewed: 1973
Share:
1 Reply
On 10 Mar 2005 10:13:54 -0800, An*************@Shell.com (Andrew
Donnelly) wrote:
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

Hi
there is a long history of posts with this error without any responses
giving a clear summary of the anwer(s), at least that I can find. The
error comes up only when the memo field is 2000-whatever in size or
larger. Answers usually concentrate on the field being bound in some
way to a form or control but I think it can occur also just as a bug
in Access, going back to A97.
If the field really is unbound, rather than using SQL have you tried
running the update by using AppendChunk in DAO? Code is fiddly but
there are examples in the A97 help file for example.
David


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by VB Programmer | last post: by
3 posts views Thread by news.microsoft.com | last post: by
reply views Thread by =?Utf-8?B?eHl6X2phdA==?= | last post: by
6 posts views Thread by =?Utf-8?B?U2NvdHQgVHJpY2s=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.