Click here to Skip to main content
15,891,757 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hi
Guys i have a datagrid view that is editable
and there is a button in my form that updates datagridview after changes

VB
Me.Validate()
Me.AABindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.AADataSet)

But when i compile and hit the button i get an error : The Query is too Complex

i searched for this error and saw that this error is because of jet adapter limitations
my dataset has at least 100 columns (maybe more)
what should i do ?
how can i use a AutoSave method for each cell ?
tnx

{oledb database - jet 4.0 adapter}
Posted
Comments
Maciej Los 25-Jul-13 3:03am    
100 columns? Is it proper table design?
KababChi 25-Jul-13 4:30am    
Yes because we use it over network and it is hard to create reports with several databases
we will switch to sql but for now we have to use this one

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900