Re: Problem using Replace function with Memo field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Christine in New Jersey (ChristineinNewJersey_at_discussions.microsoft.com)
Date: 03/07/05 

Date: Mon, 7 Mar 2005 07:21:02 -0800

John:

Thanks for replying. Sorry I have taken so long to get back to you, but I
needed to work on another project before I could get back to this one.

I've determined that the problem is not with the replace function. Rather,
whenever I attempt in code to change the field value of a memo field that
contains more than 2036 characters, I get the following error:

"Run-time '3188': Could not update; currently locked by another session on
this machine"

This happens not only on my computer using Access 2003, but also on my
client's computer using Access 2000.

Fields that are 2036 characters or less work fine.

Here is a reprensentation of the actual code:

With vTable (recordset variable; vFieldName string variable also defined)
     (other code here)
      .Edit
      .Fields(vFieldName) = "This is a test" ***ERROR OCCURS HERE***
      .Update
End With

Any ideas?

Thanks, Christine

Relevant Pages

  • Re: Truncated memo field in query & mail merge output
    ... If the memo field is greater than 255 characters, a query based on the sql ... daughter should now be wearing bermuda shorts and flip flops to school. ... Distinct or DistinctRow will all truncate a memo field to 255 characters so ...
    (microsoft.public.access.formscoding)
  • Truncated memo field in query & mail merge output
    ... If the memo field is greater than 255 characters, a query based on the sql ... daughter should now be wearing bermuda shorts and flip flops to school. ... Distinct or DistinctRow will all truncate a memo field to 255 characters so ...
    (microsoft.public.access.formscoding)
  • RE: Memos or Comments in Excel
    ... Does Excel support anything like an Accees Memo field where the ... Cells can contain 1024 characters in a formula ... Cells can contain 32,767 text characters but only the first 1023 will be ... I am using Excel 2007. ...
    (microsoft.public.excel.misc)
  • RE: INSERT INTO
    ... I did get all the syntax errors fixed but I still get the "invalid argument" ... It appears that the memo field of unlimited characters is ... Everything works fine until the text in the DESC field exceeds 127 ...
    (microsoft.public.access.formscoding)
  • Re: Memo Field Truncating
    ... If the field allows you to enter only 75 characters, it is a Text field, not ... the Format property of the text box on your form/report. ... By row under the memo field. ... > problem before and I know there's an easy fix, ...
    (microsoft.public.access.forms)