Updating datasource with dataset problem -Microsoft Access

Question

Hi I'm attempting to update details to an external Microsoft access file, database connection to the file is ok.

I'm getting the following syntax error on line "Dadapt.Update(Dset, "CustomerBook")" :

OleDBException was unhandled

Syntax error in UPDATE statement.

 Private Sub btnUpdate_Click(sender As System.Object, e As System.EventArgs) Handles btnUpdate.Click
        Dim CommandBuild As New OleDb.OleDbCommandBuilder(Dadapt)
        Dset.Tables("CustomerBook").Rows(count).Item(1) = txtbxName.Text
        Dset.Tables("CustomerBook").Rows(count).Item(2) = txtSurname.Text
        Dset.Tables("CustomerBook").Rows(count).Item(3) = txtbxaddress.Text
        Dset.Tables("CustomerBook").Rows(count).Item(4) = txtbxPost.Text
   -->  Dadapt.Update(Dset, "CustomerBook") 
        MsgBox("Details updated")
    End Sub

This error only occurs when the dataset is changed before updating.

any suggestions would be great!

Answer 1

Hi Stefan

This question would probably be better in a forum that supports database connections. It has nothing to do with the VSTO technology, so you're more likely to get quick and useful asisstance in a forum that specializes in working with data... Would you like us to move it for you?

---

Cindy Meister, VSTO/Word MVP

Answer 2

Try http://social.msdn.microsoft.com/Forums/en-US/accessdev/threads

Thanks!

---

Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)