Syntax Error occured in Insert into query(MS Access)

Question

I'm using Visual Studio 2010 and MS Access 2007

I can't fix the error

when debugging, "Syntax error in Insert Into" is occurred but sql syntax is correct I'm new to vb.net and it would be grateful if anyone can give me a solution.

   Try
        Dim query As String = "INSERT INTO User([ID],[StudName],Address])VALUES('002','haerth','col')"
        Dim comLib As New OleDbCommand
        With comLib
            .CommandText = query
            .Connection = conLib
            .ExecuteNonQuery()
        End With
        MessageBox.Show("Added Successfully")
    Catch ex As OleDbException
        MessageBox.Show(ex.ToString)
    End Try

`

Yttric · Accepted Answer · 2013-07-27 17:52:40Z

2

You have a bracket mismatch: Address]

answered Jul 27, 2013 at 17:52

Yttric

363 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax Error occured in Insert into query(MS Access)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related