Click here to Skip to main content
15,897,226 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello Guys,

I m developing a system using vb.net and access 2007 database.
I m having a problem with a query table in access, I can't save something on it.

when I try to save something through vb.net it shows this below worn message:

Update requires a valid Update Command when passed Data_Row collection with modified rows
here are the codes that brings error, I would like someone to help me know which code exactly I can use, because using update without adapter has refused working with query table, it can work only with table.
VB
Validate()
       Staff_Role_QueryBindingSource.EndEdit()
       Staff_Role_QueryTableAdapter.Adapter.Update(_CUULibDB_mdbDataSet)


Please if there someone who may know others codes of data bound control I can use instead of those one please help me know that.
Posted

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