the following error message when trying to save changes I made to
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
||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"