ETCallHome
Member
- Joined
- Apr 1, 2014
- Messages
- 5
- Programming Experience
- 10+
Hi,
I get the following error when trying to update my Dataset, i.e. I am trying to update an Access Database from VB.Net:
OLEDBException was handled
Operation must use an updateable query
Here is the code I am using
Private Sub Update_Click(......) Handles Update.Click
Please bear in mind that all the other connections, i.e. connection object, connection string, etc are all working fine. And I can successfully open and close the connection and retrieve the information. It is only when I am trying to change something in one of the records, and then updating that I get this error. If I do not change anything and just press update, then I get the "Record Updated" message.
Thanks a mill for any assistance.
ETCallHome from SA:sour:
I get the following error when trying to update my Dataset, i.e. I am trying to update an Access Database from VB.Net:
OLEDBException was handled
Operation must use an updateable query
Here is the code I am using
Private Sub Update_Click(......) Handles Update.Click
Dim cb as New OleDb.OleDbCommandBuilder(da) ... "da" declared as da As New OleDb.OleDbDataAdapter
ds.Tables("TblName").Rows(x)Items = txtSomething.Text
da.Update(ds, "TblName")
MsgBox("Record Updated")
End Subds.Tables("TblName").Rows(x)Items = txtSomething.Text
da.Update(ds, "TblName")
MsgBox("Record Updated")
Please bear in mind that all the other connections, i.e. connection object, connection string, etc are all working fine. And I can successfully open and close the connection and retrieve the information. It is only when I am trying to change something in one of the records, and then updating that I get this error. If I do not change anything and just press update, then I get the "Record Updated" message.
Thanks a mill for any assistance.
ETCallHome from SA:sour: