OleDb, Decimal and DBConcurrencyException
I had some trouble with a WebForm, including a
DataSet and uses the
OleDbCommandBuilder to publish the
CommandText property to the
DataAdapter, that tries to update five
Decimal columns in a Access database. No matter what I did, the Update method of the
DataAdapter threw a
DBConcurrencyException. After googling a few minutes I found someting about the ODBC/JET data type limit.
So I changed the
Decimal to a
Double and now all works fine.