Catch ex As Exception
MsgBox("Update failed")
End Try
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.
Here is the access database. Use Test2.zip and see test.mdb Test.zip Test2.zip
0
Larry BiedermanSoftware EngineerAuthor Commented:
I have found an answer and work around. For whatever reason this code can only save back about 95 fields. Beyond that, I used a commandbuilder and saved back as 2 recordsets and then it works.
Test.zip
Test2.zip