From within a C# application, I am using a database writer class to write to and from a Microsoft Access database. For some reason, the Read method works, but not Update.

Read sends the following command:

SELECT * FROM tblInspection WHERE ID = @ID

While Update sends:

UPDATE tblInspection SET [templateID]=[@templateID],[propertyID]...[@imageCount],[dTime]=[@dTime] WHERE [ID]=[@ID]


I've checked many times to make sure the syntax and parameters are correct. When I call ExecuteNonQuery, zero rows are returned from the Update (and the database is not changed), but when I Read, the object is returned no problems. Does anyone have an idea about what I'm doing wrong?

Thanks in advance.