Show/Hide Toolbars

Navigation: Frequently Asked Questions

ASPrunnerPro32x32     ASPRunnerPro manual

Error: Operation must use an updateable query

Scroll Prev Next More



I receive the following error message when trying to save changes I made to database:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'


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


/tablename_edit.asp, line xxx


Issue: The following error: 80004005 – Operation must use an updateable query – occurs on a page when ASP script attempts to update or insert data into a recordset.

Solution: There are several possible reasons for this ODBC error:

Inappropriate permissions set on the directory containing the database. IUSR privileges must be set to "read/write".

The permissions on the database itself do not have full read/write privileges in effect.

This error can also occur when the database is located outside of the inetpub/wwwroot directory. Though the information is still able to be viewed and searched, it cannot be updated unless it is in the wwwroot directory.

Additional information: For additional information on this error, please refer to following article in Microsoft's Knowledge Base: Q174640 - PRB: ASP: "The query is Not Updateable..." Error when Updating.

Also you can check Troubleshooting "Operation must use an updateable query" errors.