Maximum fields I can save in Bindingsource
Posted on 2014-02-04
I have run into a maximum number of fields I can save in VB.net bindingsource, using Access 2007 table.
I've use this code:
' MsgBox("Update successful")
Catch ex As Exception
I first thought I had an illegal field name, but have since found that if I try to save more than about 97 fields, it fails.
If I go into DataSources, use the wizard and remove one field (any field) from the Dataset (i.e., uncheck one box so that field is not included), the above code will save changes.
I have included Access database to demonstrate.
Experts-exchange blocks upload of the vb.net project Dataset files, but I will email to you directly if requested.
I cannot believe 96-97 fields exceed some limit of fields that can be edited and saved back.
Any help MUCH appreciated!