Adding text content to Memo field

[medirate]

I have two memo fields, Memo1 and Memo2. Memo1 cannot be edited (its locked
property is set to true).
So I have the user enter text notes in Memo2, and then I have a command
button that allows the user to add the contents of Memo2 to Memo1with the
current date. My code is as follows:
Me!Memo1 = vbCrLf & Format(Date, "mm/dd/yyyy") & vbCrLf & Me!Memo2 & vbCrLf
& Me!Memo1

Now I am recieving an error message: "Could not update. Currently locked by
another session on this machine". I belive I have about 72K characters in
the Memo1 field and was wondering if this could be the problem.

I realize that memo fields are limited to about 64k via the user interface.
But Microsoft says it goes up to 1GB when adding data programmatically. Is
my coding to add Memo2 to Memo1 incorrect, or is it the internal size limit
of the memo field that I am bumping into?

Thanks!

 

[mscertified]

I'm not sure about those size limitations but I you go up to 1 gig in a
single memo field you have real problems since you are approaching the limit
of an Access DB in a single field!
I would question your design. Why are you storing so much information in a
single memo field? Why not have a separate memo field for each update and
keep those updates in a separate table where the memo field and the
data/time/user stamp are the only fields?
You should also be aware of the problems of data corruption in using memo
fields. If you do a search of past posts you will find some recommendations
about it.

-Dorian

 

[medirate]

Thanks Dorian!
Sometimes you can't see the forest for the trees. Redesigning with seperate
memo fields makes absolute sense.