locked
Operation must use an updateable query RRS feed

  • 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.

    Wednesday, May 15, 2013 8:58 AM

Answers

  • 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! 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 16, 2013 2:07 AM
  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, May 22, 2013 1:56 AM

All replies

  • User-2005691517 posted

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

    Wednesday, May 15, 2013 10:30 AM
  • 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! 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 16, 2013 2:07 AM
  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, May 22, 2013 1:56 AM