Error updating Access Tables

Question

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?

tomekalaj · Answer

I don’t know if is some limit but you can try to take from Toolbox OleDbCommand component and write the Update command in ComandText ( in Properties ). The Dot.Net will automatically declare parameters for you and if is some limit will tell.