I have a split 2010 database that am having a problem updating a memo field when there is more than 2032 characters in the field. If I try to edit the field, I get an error message, "Could not update; currently locked by another session on this machine." The probem I am having is explained here.
For convenience, I've copied the OPs discrepancy here which is exactly the same thing I'm experiencing.
However the OP fixed the problem by using an unbound popup form. I may end up doing that, but wanted to check here first to see if anyone knew of another solution since this problem was posted over 4 years ago and I can't believe that Micorsoft hasn't addressed it with an update or something.
Any input would be appreciated before I go and re-do to an unbound form and VBA to copy the text back to the main form on close.
For convenience, I've copied the OPs discrepancy here which is exactly the same thing I'm experiencing.
However the OP fixed the problem by using an unbound popup form. I may end up doing that, but wanted to check here first to see if anyone knew of another solution since this problem was posted over 4 years ago and I can't believe that Micorsoft hasn't addressed it with an update or something.
Any input would be appreciated before I go and re-do to an unbound form and VBA to copy the text back to the main form on close.
Something is happening with memo fields when the length is greater than 2032 characters. Changes to these longer texts won't save in certain circumstances.
This is Access 2010. I have a memo field displayed on a crowded form, so it's a small display with a scroll bar. I allow the user to double-click the field to access a pop-up form that gives them lots of space to view and edit the text. The pop-up is a bound form, so it is saving as it goes.
This all works fine in most cases, but fails in one circumstance: if they have entered text longer than 2032 characters (I've done a lot of picky testing!), and then go back to that field to edit using the pop-up, the edits are lost.
I can scroll down in the original form (that tiny space) and edit the field and it's fine.
I can take a shorter text and use the pop-up to add text that brings it to more than 2032 characters and it's fine.
However, if they have already entered 2032 characters, and then I go back to that field and open the pop-up, any edits I make in the pop-up (either to add or delete text) are not saved when I return to the main field.