Memo field--not able to save addl text

[lmcc007]

Some times my memo fields will not save additional information. The text is long but not that long--it is about one to two pages. I created a save record button using a macro to see if that would save the text, but I get the following error message:

Could not update; currently locked by another session on this machine.​

What could be wrong? I am at home now--using a regular computer that is not network.

This is very annoying especially after typing a page of notes to come back to it and it's not there.

Help!!!

 

[RuralGuy]

You should be using queries for your forms and not directly to the table. Are you?

 

[lmcc007]

You should be using queries for your forms and not directly to the table. Are you?

I didn't see a reason to create a query because it is only one field using from this table and I will not be sorting or anything. I'm just keeping the memo field separate.

EventNoteID = Autonumber
EventNote = Memo

 

[RuralGuy]

Queries eliminate many locking issues.

 

[lmcc007]

Queries eliminate many locking issues.

I tried it just in case, but it did not do nothing.

I found out that this is a know problem. My research of the web showed many, many are having this same problem.

The error number for this problem is Error 3188.

When I open the memo field form by itself and save it, it works. If I have other forms opened, it won't work. Of course, that's a problem because memo is a pop-up form and so.

 

[RuralGuy]

What version of Access are you using?

 

[lmcc007]

What version of Access are you using?

Access 2007

Also, I do not get an error if the Memo field contains less than 2k characters. Or, if the form is the only form opened. Or, if I go directly into tables and save the data, I don't get an error.

 

[RuralGuy]

Great links Blaster!

 

[lmcc007]

Workaround: Error 3188 (Cannot not update Memo field with >2k characters)

Check out this link. http://sites.google.com/site/msaccesscode/forms-1

And here

I tried that already--does not work. I get another error. And, this db is displaying one form. When I display "just" the memo form, I am able to save too. Anyway, I tried both the examples given in the db, and I just get a whole new set of errors.