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.
Solved
Maximum fields I can save in Bindingsource
Posted on 2014-02-04
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.TblFlange14CalcBindingS
Me.TblFlange14CalcTableAda
' 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
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.TblFlange14CalcBindingS
Me.TblFlange14CalcTableAda
' 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
[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
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.TblFlange14CalcBindingS
Me.TblFlange14CalcTableAda
' MsgBox("Update successful")
Beep()
Catch ex As Exception
MsgBox("Update failed")
End Try
Try
Me.Validate()
Me.TblFlange14CalcBindingS
Me.TblFlange14CalcTableAda
' MsgBox("Update successful")
Beep()
Catch ex As Exception
MsgBox("Update failed")
End Try
Featured Post
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.
Suggested Courses
Course of the Month11 days, 7 hours left to enroll
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.