Windows XP (also tried this on Win7)
Access 2007
I'm having a strange problem updating a memo field. I have stripped the form down to a bare minimum and spent several hours trying to reproduce this error reliably so bear with me.
IF:
1) if a form "FORM1" has a memo field bound to a field in a query/table
2) FORM1 is *showing* (not necessarily editing) a record that has a memo field with more than 2048 characters
3) a second user attempts to edit the memo with FORM1
4) access attempts to save the record either when the user leaves the record or by running a vba command, while condition 2) is still fulfilled
THEN:
Access throws the error "Could not save; currently locked by another user"
_______________________
This is strange because:
1) if the record were being edited by another user, record-level locking would have caught this and prevented edits before user2 ever was able to start typing. FORM1 is set to lock edited records both as the database default, and in the form properties
2) this problem disappears when the char count in the memo field is less than 2048 characters, this seems to be some upper limit in a memory buffer somewhere? this is beyond my comprehension. the form behaves like normal until this threshold is passed
3) in the midst of editing this post i tried to reproduce this in a query and on the table, the same thing happens; if you view (by clicking on, not necessarily editing) the record with a memo of more than 2048 char, a second user cannot make save changes to the memo
_____________
possible solution:
maybe i could make an unbound text field that holds the memo text, and when a user edits it, the edit can be written to the record.
The only problem is that i must then handle record locking and unlocking another way
i'll take any ideas i can get! this is a very troublesome problem