Error updating Access Tables

May 23 2005 6:19 AM
I am hopefully looking for confirmation here. I am writing an application that needs to update and existing Access Database. I have written the code to allow all of the fields to be passed to the database as parameters as in the example below. OleDbCommand uCmd = new OleDbCommand("UPDATE Property SET Name=? WHERE PropertyID=?", dbConnection); uCmd.Parameters.Add(new System.Data.OleDb.OleDbParameter( "Name", System.Data.OleDb.OleDbType.Char, 50); uCmd.Parameters.Add(new System.Data.OleDb.OleDbParameter( "PropertyID", System.Data.OleDb.OleDbType.Numeric, 0); My problem is when I try to update a table which has more that 35 parameters passed to it. Is this an upper limited that is not documented?

Answers (1)