title: updating a row gives error Operation must use an updateable query
body: <p>I'm getting this error when I'm trying to update a record:</p>
  <blockquote>
  <p>ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]</p>
  <p>Operation must use an updateable query</p>
  </blockquote>
  <p>However when I add a new record, it would add just fine.</p>
  <p>I did some searching and found out that the problem is because The ASP.NET worker process does not have permission to update the database. But how am I being able to insert a new record (Isn't inserting updating the database!) but not update (set a record to a different value).</p>
  <pre><code>OdbcConnection DbConnection = new OdbcConnection(&quot;DSN=inv&quot;);
  DbConnection.Open();
  
  try
  {
      string newPassword = password1.Text;
      OdbcCommand DbCommand = new OdbcCommand(&quot;UPDATE Users&quot; + &quot; SET [Password] = '&quot; + newPassword + &quot;'&quot; + &quot; Where Name = '&quot; + Session[&quot;LoginId&quot;] + &quot;'&quot; + &quot;;&quot;, DbConnection);
      DbCommand.ExecuteNonQuery();
      Server.Transfer(&quot;Default.aspx&quot;, true);
  }
  </code></pre>