ASPrunnerPro32x32     ASPRunnerPro manual


Error: Operation must use an updateable query

<< Click to Display Table of Contents >>

Navigation:  Frequently Asked Questions >

ASPrunnerPro32x32     ASPRunnerPro manual


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.