ADO weird behaviour

[yoni]

Hi,
I have plan dataset with two tables.
Im using oledbcommand to delete records from access db.
The oledbcommand simply call access query
with parameters which are defined in the oledbcommand.

When im calling the oledbAdapter.update(dataset , dataTable) method and there are more than one row(!) in one of the tables, i receive the following error message:
"Concurrency violation: the DeleteCommand affected 0 records".

Then i tried new thing.
Im iterating manually all over the dataset rows and calling
oledbDataAdapter.update(dataRow) method for each single row.
This works fine.

Any idea why this happens??

Thanks,
Yoni

 

[samsmithnz]

I dont know whats wrong, but a simple search in Google found this article on MSDN. Maybe it can help you:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskcatchingconcurrencyerror.asp