Re: Problem using Replace function with Memo field
From: Christine in New Jersey (ChristineinNewJersey_at_discussions.microsoft.com)
Date: 03/08/05
- Next message: Henry Jordan: "Access VBA Statement (Access 2000 - Vb 6.0) "Dim MyDB As Database""
- Previous message: John Nurick: "Re: How to split a field into parts"
- In reply to: John Nurick: "Re: Problem using Replace function with Memo field"
- Next in thread: Christine in New Jersey: "Memo field problem resolved - Thanks!"
- Reply: Christine in New Jersey: "Memo field problem resolved - Thanks!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Mar 2005 07:09:01 -0800
John:
Thanks. I will try creating a new database file and copy the data to the new
file and see if that solves the problem. I will let you know how I make out.
Christine
"John Nurick" wrote:
> Hi Christine,
>
> One possibility is that the message means what it says, that something
> else (a bound form?) has locked the record(s) in question.
>
> But a web search suggest that it's also possible that the database (or
> to be precise the part of the MDB file where the contents of this memo
> field in these particular records are stored) has become corrupt.
>
> See Tony Toews's corruption FAQ at
> http://www.granite.ab.ca/access/corruptmdbs.htm, especially "To retrieve
> your data from a Corrupt Microsoft Access MDB" at
> http://www.granite.ab.ca/access/corruption/corruptrecords.htm
>
>
>
>
>
>
> On Mon, 7 Mar 2005 07:21:02 -0800, "Christine in New Jersey"
> <ChristineinNewJersey@discussions.microsoft.com> wrote:
>
> >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
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
>
- Next message: Henry Jordan: "Access VBA Statement (Access 2000 - Vb 6.0) "Dim MyDB As Database""
- Previous message: John Nurick: "Re: How to split a field into parts"
- In reply to: John Nurick: "Re: Problem using Replace function with Memo field"
- Next in thread: Christine in New Jersey: "Memo field problem resolved - Thanks!"
- Reply: Christine in New Jersey: "Memo field problem resolved - Thanks!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
