A very old app of mine that's been in production use, and largely
unchanged since about 1998 has started recently throwing error 3188
(can't update, locked by another session on this machine) when
saving edits to some memo fields.
I have found a number of things:
1. it happens only with long memo fields, starting somewhere above
255 characters (though I don't know exactly where.
2. it happens only on fields that have multiple controls that
display their data.
In the form I'm having the problem with, it's based on a table with
multiple record types, so two different tabs have controls with the
field displayed on them, though only one is visible at a time. There
is also a subform built on the same table that is non-editable that
displays a summary version of the record (it formats it like the
client's printed catalog entries).
I've solved the problem by tracking changes to the controls and
saving the record after either of the controls is updated. But the
only way to make it not error out is by swapping out the subform.
This did not used to happen -- it seems to have started happening
only in the last few weeks.
Any ideas on this?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc