Error using command.ExecuteNonQuery [resolved]

[ERage]

I recieve an error that says: "Syntax error in UPDATE statment" when executing the following code.

Dim strConn As String
        Dim strSQL As String
        Dim connection As New OleDb.OleDbConnection
 
        strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\inetpub\wwwroot\Webapplication1\isi.mdb"
 
        strSQL = "UPDATE keygenerator SET Section = 'H'  WHERE RNDID = '" & ModGlobal.key & "'"
 
        connection.ConnectionString = strConn
        connection.Open()
 
        Dim command As New OleDb.OleDbCommand
        command.CommandText = strSQL
 
        command.Connection = connection
 
        Try
 
            command.ExecuteNonQuery()
        Catch ex As OleDb.OleDbException
            ASPNET_MsgBox(ex.Message)
        End Try

I have tested the actual SQL statement that is generated in this code using my database and it runs fine so the error shouldn't be an SQL issue. I usually program windows apps and this is my first ASP.NET web app. Is this method of executing a nonquery legal in a webapp? Any help is appreciated. thanks in advance.

[MrNorth]

the syntax looks fine to me... what kind of dbtype is the key value? Is it possible it is a number field and you use ' ' around it?

perhaps someone else with sharper eyes than me can find any other problems?

kind regards
Henrik

[ERage]

Unfortunately both fields used in the query are stored as text in the DB (for the purpose of keeping leading zeros on the RNDID number).

[ERage]

I think I got it, I changed section to another term and it worked
fine. possibly a keyword? anyways, thanks for the help