Hi,<BR>I have simple dataset with two tables:Primary table and foreign table<BR>which are related in ONE-TO-MANY relationship.<BR>I&#039;m trying to update the dataset into db with oledbCommand which simply call<BR>a query on access mdb file.<BR>Sometime when i call the oleDbAdapter.update method i get the following error message:<BR>"Concurrency violation: the DeleteCommand affected 0 records"<BR><BR>This happens only when one of the tables has more than one row!<BR>If each table has one row everything works fine.<BR><BR>Any idea why this happens??<BR><BR>Thanks,<BR>Yoni<BR><BR>