general conflict question

[JohnE]

Hello. The issue is the Write Conflict error that occurs randomly to some
users. It seems to occur in a continuous form. An example would be the form
has 30 records listed but 6 records have the Write Conflict appear with the
Save Record dimmed out. What is even more baffling is that the Write
Conflict occurs only on one field within the record. The field is a text
field. The back end is SQL Server 2005. The data type there is okay. It is
very rare (to non-existent) that someone would be on the same record (or
field). This has been an issue for a long time.

Have others had this issue and if so, what was done to correct it or
eliminate it?

Thanks.
John

 

[Marshall Barton]

Hello. The issue is the Write Conflict error that occurs randomly to some
users. It seems to occur in a continuous form. An example would be the form
has 30 records listed but 6 records have the Write Conflict appear with the
Save Record dimmed out. What is even more baffling is that the Write
Conflict occurs only on one field within the record. The field is a text
field. The back end is SQL Server 2005. The data type there is okay. It is
very rare (to non-existent) that someone would be on the same record (or
field). This has been an issue for a long time.

Have others had this issue and if so, what was done to correct it or
eliminate it?

I had a similar issue once. It turned out that I had a line
of code a form's current event that set the value of a bound
text box. I had originally intentded to set the text box's
DefaultValue and brain fault let me just type Value instead.
That meant every record any user navigated to with the mouse
or arrow/enter keys would be dirty and require a save and
generate lots of write conflicts. Took me forever to find
the problem.