Here's where I'm stuck...

I'm working on a small learning project and I'm having a problem updating my data files... (I'm using a copy of the Northwind database which is designed for use with Access. I'm using the Orders and Employees tables.)

In my current implementation I used the wizards for the DataAdapters and DataSets and bound my DataGrid and textboxes to fields in my DataSets.
I don't understand why my update code isn't updating (and my insert code isn't inserting)...

I have a form where I let the DataAdapter wizard create the code to update the Northwind Employees table.
On my form I display all the fields of the table.
All the information displays correctly.

Originally the wizard generated a large complex SQL UPDATE statement. I've simplfied that, hard coding the information, down to

UPDATE Employees SET
LastName = "Brown_10"
WHERE (EmployeeID = 10)

Even so, when I do an

Dim UpdateResult As Integer = -1
UpdateResult = OleDbDataAdapter2.Update(DSemployees1)

the OleDbDataAdapter2.Update returns a zero indicating it didn't update anything

Why would that be?

(BTW - Yes, I do have a record where EmployeeID = 10 and that record's current last name is "Brown" not "Brown_10")

I've been stuck on this since last week!
I'm completely baffled!
Any help would be greatly appreciated!
Someone please help!

Rick