>In the properties window of the form I have Buffermode set to 1 - Pessimistic.
>
>In the properties window of the DE I have Buffermodemodeoverride set to 1 - Use Form Setting. Is this where I need to change it to 4 - Pessimistic Table Buffering?
>
>Or do I do it somewhere else?
I would use 5 - Optimistic table buffering. Usually I set it in code with cursorsetprop()