There are Northwind for SQL and Northwind for Access... The one I'm using is for Access.
----------
>Wait, isn't the Northwind Database a SQL Server database (or is this Access or VFP)? If it's SQL Server, you should be using SqlDataAdapter instead of the OleDbDataAdapter. Shouldn't make a difference, but maybe it is.
>
>~~Bonnie
>
>>>Rick,
>>>
>>>I haven't looked through all your code, but my first reaction to this is that you need to do an .EndEdit() or an .EndCurrentEdit(). Have you checked that MyDataSet.HasChanges() is returning a true?
>>>
>>>~~Bonnie
>>----------------------
>>Bonnie,
>>
>>I haven't done those things but I have tried simplifying the generated code to:
>>UPDATE Employees SET
>> LastName = "Brown_10"
>>WHERE (EmployeeID = 10)
>>
>>And my
>>UpdateResult = OleDbDataAdapterEmployees.Update(DSemployees1)
>>still returns ZERO indicating that no records have been updated
>>and an inspection of the Northwind Employees Table confirms this.
>>(BTW - Yes, I do have a record where EmployeeID = 10 and that record's current last name is "Brown" not "Brown_10")
>>
>>Rick
>>-----------------