Fix :: Operation must use an updateable query." for ASP pages

Fix :: Operation must use an updateable query." for ASP pages

Fix :: Operation must use an updateable query." for ASP pages

Problem Statement
Operation must use an updateable query." for ASP pages
 

Cause
There might be several reasons for this error. One of the most common reason 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. Login to your server with administrator user.
  2. Locate 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 on OK.

    • Related Articles

    • Creating Virtual Directory for ASP.Net application

      Creating a Virtual Directory for ASP.Net application Description: A virtual directory is a link to an existing physical directory that is present on the server's hard disk. Virtual directories can have a number of specific settings like custom ...

    • How to use MSSQL Activity Monitor to find the most expensive query

      There are certain ways to identify and troubleshoot long running queries.This prevents potential performance issues. SQL Activity Monitor is the easiest and rich UI tool available in SQL Server Management Studio.It provides information about ...

    • How to Increase the MS SQL Remote Query Timeout

      MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds), a remote operation can take before SQL Server times out. Note that, it only applies to an outgoing (not incoming) connection initiated by the Database Engine as ...

    • Change ASP.NET Framework Version for your domain or subdomain in Plesk

      Change ASP.NET Framework Version for your domain or subdomain in Plesk Description: ASP.NET is an open-source server-side web application framework designed for web development to produce dynamic web pages developed by Microsoft to allow programmers ...

    • How to Fix HTTP Error 500 (or 500.21) - Internal Server Error Handler SSINC-shtml.

      Error Message HTTP Error 500 (or 500.21) - Internal Server Error Handler SSINC-shtm' handler Solution To fix this, we need to install required IIS features to execute the SSINC-shtm handler. Please follow below steps to install required IIS features. ...