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 article.