write conflict

[dfeigen115]

I am getting a write conflict ("another user has chnaged the record...) when
processing a form. the process flow has the user selecting a record for
update, which displays a form with a variety of protected data elements, the
user reviews the displayed data and then selects either an approval or
disapproval checkbox. depending on which check box is selected additional
fields are made visable, the user populates the new fields and clicks the
"save" button. The save processes the data (does some basic validations) and
displays the "sucessfull update" msg. After this msg is displayed, the user
gets a "write conflict" popup. there are no other users in the applicaiton
at the time.

Any assistance would be greatly appreciated.
Dan

 

[Paul Shapiro]

If the data is updated by running a sql update statement in VBA code, that
would be the "other" user. If you're data is in SQL Server, there are other
possible causes. Either post some more details, or search on the phrase
"another user has changed the record" which should return alternative
solutions.

 

[dfeigen115]

Paul,
that was it. I had updates from the data entry on the form followed by
addiitional updates via SQL. The form data save was sequenced after the sql
statements, creating the conflict. Once I rearranged the code, the conflict
went away. Thanks for your insight.
Dan