William,
You are correct, you need to change the BufferModeOverride on the cursor in the DE. The form setting chooses row or table based on the controls used in the form, if a grid is used then table applies otherwise it is row. It is because of this "magic" that is done that I never use the form setting.
Also, if you think you may ever go to a Client/Sever system, you should get used to the optimistic approach as pessimistic is not an option with data base servers on the backend.