I have a form with 5 tables in the dataenvironment. The buffermodeoverride is set to 1 for all of the tables.

Hmmm. Not a good idea - you would be better of to set it to 5 - Optimistic table buffering.

It sounds to me like you do not have a very good understanding of what buffering is all about. You may find it helpful to download my husbands white paper A Guide to Buffering and Transactions in VFP