I have a form that has BufferMode set to "2" for optimistic. In the Data Environment of that form, there is a table that has BufferModeOverride set to 1 (use form setting). On the form, there is a text object with a control source set to one of the fields in the table.

I was under the assumption ... and this is where I get in trouble ... that the only way the table would actually get updated is if and when I issue a TABLEUPDATE command. Therefore, the user could change the data in the textbox as many times as they wanted and it wouldn't really change the underlying table as long as I don't issue a TABLEUPDATE. I also assumed I could issue a REPLACE command and it also wouldn't permanently change the table as long as I never issued a TABLEUPDATE.

Could someone please tell me where I've gone wrong in my assumption, because the table is getting changed and I've never issued a TABLEUPDATE command in that form. And when two users have been in this form, and the first user exits, and then the second user exits, the second user gets an UPDATE CONFLICT error on this table when the DataEnvironment is being closed out (I've determined this because this table is the 5th table out of many and when the error occurs, the first four tables are closed.)

Thanks in advance!
Cathy