Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Maximum fields I can save in Bindingsource

Posted on 2014-02-04
2
Medium Priority
?
333 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
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.

719 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