I am using Access2010 and VB2008 Express for my application. I get a Syntax error in

[arseno]

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim Cmd As New OleDbCommand
        Dim SQL As String
        Dim DbCmd As New OleDbCommand
        Dim conn As New OleDbConnection()
 
 
 
        conn.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=C:\Documents and Settings\Owner\My Documents\Results2012.accdb"
        conn.Open()
        SQL = "INSERT INTO Game_Summary(Week,Opponent,Game1,Game2,Game3,OP Game1,OP Game2,OP Game3,Series,OP Series,Wins,OP Wins)" & _
        "VALUES('?','?','?','?','?','?','?','?','?','?','?','?');"
        Cmd = New OleDbCommand(SQL, conn)
        Cmd.Parameters.AddWithValue("Week", ListBox2.Text)
        Cmd.Parameters.AddWithValue("Opponent", TextBox89.Text)
        Cmd.Parameters.AddWithValue("Game1", TextBox26.Text)
        Cmd.Parameters.AddWithValue("Game2", TextBox27.Text)
        Cmd.Parameters.AddWithValue("Game3", TextBox28.Text)
        Cmd.Parameters.AddWithValue("OP Game1", TextBox55.Text)
        Cmd.Parameters.AddWithValue("OP Game2", TextBox67.Text)
        Cmd.Parameters.AddWithValue("OP Game3", TextBox68.Text)
        Cmd.Parameters.AddWithValue("Series", TextBox29.Text)
        Cmd.Parameters.AddWithValue("Op Series", TextBox83.Text)
        Cmd.Parameters.AddWithValue("Wins", TextBox63.Text)
        Cmd.Parameters.AddWithValue("Op Wins", TextBox71.Text)
 
 
 
        DbCmd = New OleDbCommand(SQL, conn)
        DbCmd.ExecuteNonQuery()
        conn.Close()

[Rabbit]

Please use code tags when posting code.

I have no idea what your question is.

But I'll take a stab at the solution and it's because you use nonstandard characters in your field names (in this case, spaces). When you do that, you must demarcate it as a field using square brackets.

[OP Game1]

You should also not give your parameters the same name as your fields, that will just cause ambiguity.

[arseno]

Thanks,
I understand completely