Start New Discussion within our Software Development Community

I know i'm probably goin about this bassackwards. But,

window is loaded, binded textboxes get filled, user edits textboxes and clicks a save button

it works, all except crashing with a " 2010 Concurrency violation: the UpdateCommand affected 0 of the expected 1 records." most of the time but the data does get updated

any ideas on how to be rid of this error will be much appreciated
thnx n adv

'form.vb code for button_click
Dim dtNewRow As DataRow
dtNewRow = dbDataSet.Table.NewRow()
dtNewRow.Item(dbDataSet.Table.Column) = Textbox.Text  '<--this line is followed by 33 more that vary on column and textbox



'dbDataSet.designer.vb erroneous section
<Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
         Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", ""), _
         Global.System.ComponentModel.Design.HelpKeywordAttribute("")> _
        Public Overridable Overloads Function Update(ByVal dataTable As dbDataSet.TableDataTable) As Integer
            Return Me.Adapter.Update(dataTable)  '<--the UpdateCommand affected 0 of the expected 1 records.
        End Function 2010
access 2010 db file .accdb

This article has been dead for over six months. Start a new discussion instead.