Re: Write Conflict - Open Record


"Ryan Langton" <langton@xxxxxxxxxxxxxxxxxx> a écrit dans le message de news:
%23KS2ruEaFHA.3400@xxxxxxxxxxxxxxxxxxxxxxx
>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
>


.