I'm having some trouble getting this example to work. The only edit I've made to the code is to change the connectionString to that appropriate for a database running on my local machine, the rest of the example having been downloaded directly from the sample online code. The error I'm getting is that the call to
, which appears on Line 92 in the original sample code, produces the error
System.Data.OleDb.OleDbException: Operation must use an updateable query.
The query in question, I take it, is the
SELECT EmployeeID, FirstName, LastName FROM Employees;
one used to instantiate the dataAdapter?
I've checked this query physically within Northwind.mdb, and it produces an editable result using Access's own query tool. I've tried removing all relationships with other tables in Northwind to see if that fixed the problem, but had no luck with that.
Do any of you have any ideas on what's producing the error?