Problem Statement

The operation must use an updateable query." for ASP pages

Cause

There might be several reasons for this error; one of the most common reasons is inappropriate permissions.

Error message

Getting the error Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/myfolder/test-page.asp, line 315

Solution

1. Log in to your server with the administrator user.
2. Locate the wwwroot folder of your website
(usually located at c:\inetpub\ or c:\Hosting Spaces\Domain.com\)
3. Click on Properties >> Security.
4. Click on Edit and select the IIS_IUSRS.
5. Check the checkbox against necessary permission (Read, Write, and Modify) from the permissions list and click OK.