Write Conflict - Open Record

[Ryan Langton]

I recently converted an .mdb application to an .mdb with SQL linked tables.
I have several forms that allow a user to enter in a new record and then
click a save button (the code runs DoCmd.RunCommand acCmdSave). Since
converting, these forms are giving me a Write Conflict error when I click
the save button - something like "Warning - the data cannot be saved because
another user has the same record open - Copy to Clipboard or Drop Changes"
(the Save Record button is disabled on this warning popup). I then end up
with an open record in the database which I cannot close or delete without
physically going to the SQL server and deleting the record.

Any ideas what could cause this problem?

Thanks,
Ryan

 

[Ryan Langton]

I have narrowed the problem down some. It appears that there are some
UPDATE and INSERT INTO queries written into the code everywhere this problem
exists. Still looking..

 

[Ons]

I recently converted an .mdb application to an .mdb with SQL linked tables.
I have several forms that allow a user to enter in a new record and then
click a save button (the code runs DoCmd.RunCommand acCmdSave). Since
converting, these forms are giving me a Write Conflict error when I click
the save button - something like "Warning - the data cannot be saved
because another user has the same record open - Copy to Clipboard or Drop
Changes" (the Save Record button is disabled on this warning popup). I
then end up with an open record in the database which I cannot close or
delete without physically going to the SQL server and deleting the record.

Any ideas what could cause this problem?

Thanks,
Ryan

 

[sunny]

thanks!