[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

Maximum fields I can save in Bindingsource

Experts,

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:

Try
            Me.Validate()
            Me.TblFlange14CalcBindingSource.EndEdit()
            Me.TblFlange14CalcTableAdapter.Update(Me.JobsDataSet.TblFlange14Calc)
            ' MsgBox("Update successful")
            Beep()

        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.

Any help MUCH appreciated!

-Larry
0
Larry Biederman
Asked:
Larry Biederman
  • 2
1 Solution
 
Larry BiedermanSoftware EngineerAuthor Commented:
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.

Try
            Me.Validate()
            Me.TblFlange14CalcBindingSource.EndEdit()
            Me.TblFlange14CalcTableAdapter.Update(Me.JobsDataSet.TblFlange14Calc)
            ' MsgBox("Update successful")
            Beep()

        Catch ex As Exception
            MsgBox("Update failed")
        End Try
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now