Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Write-conflict

Author  Topic 

mharvey
Starting Member

13 Posts

Posted - 2003-11-17 : 11:12:17
Hello:

We are in the process of converting ACCESS tables to SQL Server; an ACCESS front-end will still be used.

There are two forms that write new rows to the SQL tables using ADO code. We receive a dialog box entitled "Write Conflict"; the text of the error is:
"This record has been changed by another user since you started editing it.If you save the record you will overwrite the changes the other user made."
There are 3 buttons:
Save Record Copy To CLipboard Drop Changes.
(The Save Record button is NOT enabled.)

Service packs are up-to-date on the Win2k and Win98 machines on which this occurs.

Any ideas?
Thanks,
Michael
   

- Advertisement -