2. ASPRunnerPro General questions
  3. Error: Operation must use an updateable query.
This topic is locked

Error: Operation must use an updateable query.

 		3/1/2003 9:27:13 PM
ASPRunnerPro General questions
author

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
Admin 3/2/2003

Issue

The following error: 80004005 - Operation must use an updateable query - occurs on a page when an event is updating or inserting into a recordset.
Solution
There are several things that may cause this ODBC error. Many of the possible reasons are listed in the table below.

  • The permissions that are set on the directory the database is in. IUSR privileges must be set to "read/write".
  • The permissions on the database itself does 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
500001 7/17/2003

go to the folder where the db is stored and right click select security and add isusr make sure you untick the propogate field and give read / write access to the folder.

Rob. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=349&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />