ERROR [HY000] Operation must use an updateable query

Ever seen this error when trying to update your MS Access database from ASP.NET?

When developing a website you may find that everything is working fine, until that is you come to the point where you need to update table rows or insert new rows, at which point you may be presented with the following error.

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query

The cause of this is lack of permissions for the ASPNET user to write to the folder. To remedy this situation follow these steps

  1. Open the file explorer
  2. Tools menu
  3. Options menu
  4. Click the [View] tab
  5. Uncheck "Use simple file sharing"
  6. Click OK
  7. Find the folder in which your MDB file is kept
  8. Right-click the folder
  9. Select "Sharing and security"
  10. Click the [Security] tab
  11. Click the Add button
  12. Click the Advanced button
  13. Click the Find Now button
  14. Select the ASPNET user and click OK
  15. In the checkboxes at the bottom of the form, give this user Full Control

 

 

Share this article!

Follow us!

Find more helpful articles:

Comments

Jun
11

This happens when the field you are trying to change comes from a table without a key field joined to another table in the query. It may be possible your database is corrupted or virus affected. You can use compact and repair utility or stellar access repair utility which will repair your database and you get rid from this error

By vish dwi