c# - Access DB - Operation must use updateable query -


I have a website that I created in VS2005, C #, .NET 2.0. This website deals with an Access database. It works fine in development The MDB file resides in App_Data

I have to test this machine to setup the website because it will be deployed. I have published the site in my IIS virtual directory. all went well.

Every time I try to update, insert or delete, I get the error above "Operation needs to use an updateable query."

I have applied the following permissions to the App_data folder: / P> 

  modify machinename / IUSR - machinename / ASPNET - Modify network service - Domain name / myaccount - full < / Code>

I went crazy and gave full permission to the group, but it does not work either

In my web configuration I have the following line: 

  & lt; Identification impersonation = "true" />

This application is impersonated to provide access to the application for my login account.

I still can not insert, update or delete the query. Any ideas?

Update:

Thanks for the response I have read that article I have also read about the first 4 pages of Google results and all of them Let's talk about permissions in the DB folder.

  1. My permissions have been set as MS article.
  2. The database is being opened in correct mode, otherwise it will
  3. I am not using the ODBC, so coming out.
  4. I'm not using SQL Server, so it's also out.

    5. Other possible reasons are given.

    Update: Have you checked the effective permissions? Perhaps due to clear rejection the heritage comes into play here.


Comments

Post a Comment