Contents

 
Home
ASPRunnerPro 9.7 manual
Prev Page Next Page
 
 

Error: Operation must use an updateable query

 

Question:

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

Answer:

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.

 

Converted from CHM to HTML with chm2web Standard 2.85 (unicode)