Operation must use an updateable query

Question

User1357926729 posted

hi..

I am using ASP.net 4.0 and MS access 2010  as database.my website was working fine locally.When i hosted it in the web,during insert operation,this error is coming: "Operation must use an updateable query".What should i do to solve this error.I tried to change the permissions in the app_data folder,but already read and write options are given for the user and administrator.Should i login as administrator to solve this issue.Please someone help me..I'm really in trouble.

Answer 1

User-2005691517 posted

Check the user context under which your web application is running. Have you granted write permission to that user?

Answer 2

User1196771204 posted

hi there,

I have come across this error message: "Operation must use an updateable query" in the past and this issue is pertaining the non-existence of the WRITE permission on your folder. Once you have it granted and inherited to all its subfolders, everything will work as usual

Please mark this response as an "Answer" if it helps you. Thanks heaps! 

Answer 3

User1357926729 posted

My issue is solved.the web hosting company had to change the settings to the folder containing database in the web hosting server.They gave access to anonymous users.Now i can write and update the database.