Well, first of all, you can't do an .AcceptChanges() before you attempt to Update ... the .AcceptChanges() marks the rows as having no changes and so the .Update() thinks nothing needs updating. There may be other issues (not having seen your code, I don't know) ... but take care of this first and see if that helps.

~~Bonnie



>Yes, I used that and is work. But i have a new problem. When i update the dataset using that code below it didnt work...
>
>

>da = new OleDbDataAdapter
>
>dtEmployee.AcceptChanges
>da.Update(dtEmployee)
>

>
>My intention here is to commit the new record in my database. No syntax error happened but when I check my database, new record is not added. Is their something I need to do in updating dataset?