write conflict

D

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
 
P

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.
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Split form 0
Write Conflict 8
write conflict 4
general conflict question 1
Write Conflict 3
Write Conflict 2
"Write Conflict"? Why? 5

Top