MS Access Update Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Heavey (JimHeavey_at_discussions.microsoft.com)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 15:29:03 -0800

I am running WinXP with and ASP.Net application.
When I invoke a stored Access query which is going to update a table, I get
and error message of "Operation must use an updateable query". Microsoft has
a KB article on the subject and it indicates that the problem is a security
issue and that I need to grant read/write authority to "IUSER".
I went to the folder which contained my folder within the wwwroot directory.
 Using Windows Explorer I clicked on the IUSER Account and granted it "Full
access" to the folder which contains my file as well as the file itself, but
this has had no effect. So I am not doing something correct. Is the "IUser"
not the correct account for ASP.Net for XP or have I done something incorrect
in granting authority to IUser?

When I look at the file permissions of the directory, I see the "Deny"
greyed out but checked for "Special Permissions" and "Write". the "Special
Permissions" is not checked for "Allow" and it is checked for "Special
Permissions". Is this the way it is suppose to be?

Thanks in advance for your assistance!!!

Relevant Pages

  • Re: Securing IIS IUSER
    ... worked when the Users group had Read permission on the folder. ... > I then explicitly granted it read permissions to the wwwroot, ... Before granting IUSER permission to read the files/folder, ...
    (microsoft.public.windows.server.security)
  • Re: Securing IIS IUSER
    ... so that these account are not effectively Users members, ... > I then explicitly granted it read permissions to the wwwroot, ... Before granting IUSER permission to read the files/folder, ... > are any of these permitting IUSER access to files and folders with "Users" ...
    (microsoft.public.windows.server.security)
  • Securing IIS IUSER
    ... from the "Users" group and added it to the "Guest" group. ... I then explicitly granted it read permissions to the wwwroot, ... Before granting IUSER permission to read the files/folder, ... I want to stop IUSER see files and folders unless granted ...
    (microsoft.public.windows.server.security)
  • IUSER and Write Access Problem
    ... I am having an argument with someone right now about permissions and the ... anonymous IUSER. ... This person has insisted that I give the IUSER write ... permissions to a web site he is developing so that he can get his ASP code ...
    (microsoft.public.inetserver.iis)