Hi,

Can someone help me get around the following problem please?

I have an Access database which can be accessed by more than one instance of my application (which is) a Form with a DataGridView on it.

I populate the DGV with

Code:
Form1.Validate()
Form1.CHECKLISTBindingSource.EndEdit()
Form1.CHECKLISTTableAdapter.Update(Form1.chkDataSet.CHECKLIST)
The Access Database can then be updated via the DGV by a button click (which runs the code above (to copy across the latest copy of the DB) and then runs the code below to copy your changes to the DB)

Code:
Form1.CHECKLISTTableAdapter.Fill(Form1.chkDataSet.CHECKLIST)
Form1.DataGridView4.DataSource = Form1.CHECKLISTBindingSource
Form1.DataGridView4.Refresh()
The Access table is basicaly a 'Time' Column and a 'Name' Column.

All instances of the App work well until someone updates a Record (i.e. Name) which has already been updated by someone else.

I then get the following ...

DBConcurrencyException Was unhandled

Concurrency Violation: The UpdateCommand affected 0 of the expected 1 records.


Thanks for any help

D