Concurrency violation: the UpdateCommand affected 0 of the expected 1 records Access Database

Question

Hallo,

I have an access database bound to the data grid view using a binding source. I edit my row and try to update the database, but I'm getting a Concurrency violation error. Please help.

Using conn As New OleDbConnection(ConnStr)  

                Dim selectCommand As New OleDbCommand(CmdStrEqp, conn)  
                Dim da As New OleDbDataAdapter(selectCommand)   
 
                Dim cb As New OleDb.OleDbCommandBuilder(da)  
                cb.QuotePrefix = "["  
                cb.QuoteSuffix = "]"  
  
                da.Update(DS.Tables("Project"))  
                DS.Tables("Project").AcceptChanges()                 
  
 End Using  

Thanks

Answer 1

Hi @Hobbyist_programmer
A concurrency error occurs when the data you're trying to update has already been updated between the time you got the data you were changing and the time you're trying to execute your update.
It is recommended that you step through to see which step in your code is causing this data problem.
Best Regards.
Jiachen Li

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.