Operation must use an updateable query - question
-
Hello
I am getting the following error:
System.Data.OleDb.OleDbException: Operation must use an updateable query.
when I type in a valid user's email (he exists in the Access mdb) on this page:
forgotten password[^] I have read a couple of articles on this question, including this one: Solve Operation Must Use an Updateable Query Error in Access[^]
and have set my permissions accordingly. The folder that houses my Access database, App_Data, has the following permissions: SYSTEM, Steve, and Administrators have full permissions, and Home Users have all permissions apart from Full Control.
[^]
After compiling my project, that folder is now on the server of my Web hosting service and these are the file permissions of App_Data on the server:
[^]
However, I am still getting the same error. Do I need to do anything in the Control Panel of the server, too (I have a Web hosting service) or is what I have already enough>
Thank you.
-
Hello
I am getting the following error:
System.Data.OleDb.OleDbException: Operation must use an updateable query.
when I type in a valid user's email (he exists in the Access mdb) on this page:
forgotten password[^] I have read a couple of articles on this question, including this one: Solve Operation Must Use an Updateable Query Error in Access[^]
and have set my permissions accordingly. The folder that houses my Access database, App_Data, has the following permissions: SYSTEM, Steve, and Administrators have full permissions, and Home Users have all permissions apart from Full Control.
[^]
After compiling my project, that folder is now on the server of my Web hosting service and these are the file permissions of App_Data on the server:
[^]
However, I am still getting the same error. Do I need to do anything in the Control Panel of the server, too (I have a Web hosting service) or is what I have already enough>
Thank you.
When you use an Access database, the code needs to be able to create, modify and delete files in the directory containing the
.mdbfile. In ASP.NET, the server-side code does not run as a normal user. Depending on the settings for your AppPool, it will either run as a specific user for that pool, or as the Network Service account. On your local machine, you need to give theIIS_IUSRSgroup "modify" access to the folder. This group contains all of the AppPool-specific users created by IIS. You'll need to contact your hosting company to find out what permissions you need to apply there.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
