Solved

Maximum fields I can save in Bindingsource

Posted on 2014-02-04
2
332 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

RHCE - Red Hat OpenStack Prep Course

This course will provide in-depth training so that students who currently hold the EX200 & EX210 certifications can sit for the EX310 exam. Students will learn how to deploy & manage a full Red Hat environment with Ceph block storage, & integrate Ceph into other OpenStack service

Question has a verified solution.

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

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

627 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