01 Mayıs 2012 Salı 04:52
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!
- Taşıyan Bob_BaoMVP 03 Mayıs 2012 Perşembe 04:25 (From:Visual Studio Tools for Office)
01 Mayıs 2012 Salı 07:31
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
- Düzenleyen Cindy Meister MVPMVP 01 Mayıs 2012 Salı 07:31 added question about moving
04 Mayıs 2012 Cuma 04:47Sahip