I receive the following error message when trying to save changes I made to database:
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.