Error updating Access Tables

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

tomekalaj21y ago
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.