Hi. feels a little odd replying to my own post, but i think i've found the problem. This is my Theory.
When the user enters data into a field and clicks on the update button that uses db.execute to update the db directly, it changes the record in the db. however after this update there is a Me.refresh command that tells the form to update itself. it then finds that the records is different from the one in the buffer and throws up the write...
Kuriandungu
Last Activity: Sep 9 '08, 10:41 AM
Joined: Mar 6 '06
Location:
-
Write Conflict Access97 to SQL 2000 bound form
Hi guys
I've read the posts on Write conflict entered in this forum (along with some from kbAlertz and microsoft) and i have tried all the solutions without success. let me give you some background.
i have an access form bound to a customers table in sql. the table in sql has an index on the customer code and has an autoincrement field generated by sql (rowid). i have also put a time stamp field.
My Access form does not...
No activity results to display
Leave a comment: