Operation must use an updateable query ASP.NET with Database

Posted By  RRaveen On 19 Apr 2011 09:04:44
emailbookmarkadd commentsprint
No of Views:666
Bookmarked:0 times
Votes:0 times

Problem

When you are work with asp.net and database,sometime  you may receive error "Operation must use an update able query." update database with your data access.

Cause of Error

There are couple of things to check,

  1. File may be readonly
  2. Application pool is readonly

Solutions

  • The file marked as readonly, if yes, then right click file and uncheck read only option.
  • The application pool identity doesn’t have write permissions to the folder that contains the MDB. Find the identity of the application pool (using IIS) and (using Windows Explorer) give that identity (usually Network Service) write permissions to the folder.
  • Here is more possible solutions http://support.microsoft.com/kb/175168

Hopes help and save your time.

 

Sign Up to vote for this article
Other popular Tips/Tricks
Comments
There is no comments for this articles.
Leave a Reply
Title:
Display Name:
Email:
(not display in page for the security purphase)
Website:
Message:
Please refresh your screen using Ctrl+F5
If you can't read this number refresh your screen
Please input the anti-spam code that you can read in the image.
^ Scroll to Top