title: Writing an update query in asp.net (access database) (visual basic)
body: <p>I have this code:</p>
  
  <pre><code>    Dim pathString As String = HttpContext.Current.Request.MapPath("Banking.mdb")
      Dim odbconBanking As New OleDbConnection _
               ("Provider=Microsoft.Jet.OLEDB.4.0;" &amp; _
               "Data Source=" + pathString)
      Dim sql As String
      sql = "UPDATE tblAccounts balance = " &amp; CDbl(balance + value) &amp; " WHERE(accountID = " &amp; accountID &amp; ")"
      odbconBanking.Open()
      Dim cmd As New OleDbCommand(sql, odbconBanking)
      cmd.ExecuteNonQuery()
  </code></pre>
  
  <p>However, an exception is thrown, when I run it:
  Syntax error in UPDATE statement. </p>
  
  <p>I tried to run a similar statement in Access and it works fine.</p>