Solved

Maximum fields I can save in Bindingsource

Posted on 2014-02-04
2
329 Views
Last Modified: 2014-02-11
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
Comment
Question by:Larry Biederman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Author Comment

by:Larry Biederman
ID: 39833441
Here is the access database.  Use Test2.zip and see test.mdb
Test.zip
Test2.zip
0
 

Accepted Solution

by:
Larry Biederman earned 0 total points
ID: 39851747
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IDE for Python 5 109
Need to sort columns in DataGridView 4 64
Error building VS2105 solution from repository 1 62
How do I "share" on social sites? 2 39
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question