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

MS Access Update Query by Elton

Elton
Thu Feb 17 18:42:43 CST 2005

Hi Jim,

Although I am not sure for XP, you can try ASPNET account.
It's for Win2K.

HTH,

Elton Wang
elton_wang@hotmail.com

>-----Original Message-----
>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!!!
>.
>

RE: MS Access Update Query by JimHeavey

JimHeavey
Thu Feb 17 22:25:02 CST 2005

I have the following accounts which show up in XP...
Administrator
Creator Owner
Everyone
Ineternet Guest Account (IUSR)
VS Developers
Users
System
Launch IIS Account

Now if I go into Local Users and Groups....I see "ASPNET" account, but I can
not see that account when I am using windows explorer and selecting "Sharing
and Security". So am I suppose to be using windows Explorer to "grant" this
access? Why does the "ASPNET" account not show up there?



RE: MS Access Update Query by Mark

Mark
Fri Feb 18 00:51:02 CST 2005

Just as an aside - are you writing a corporate application or is this just a
'hobby' application. If it is the former, then Access is not the best choice
of database engine....MSDE would be more appropriate

"Jim Heavey" wrote:

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

RE: MS Access Update Query by Elton

Elton
Fri Feb 18 07:25:05 CST 2005

You can add the ASPNET account to local.

HTH,

Elton Wang

>-----Original Message-----
>I have the following accounts which show up in XP...
>Administrator
>Creator Owner
>Everyone
>Ineternet Guest Account (IUSR)
>VS Developers
>Users
>System
>Launch IIS Account
>
>Now if I go into Local Users and Groups....I see "ASPNET"
account, but I can
>not see that account when I am using windows explorer and
selecting "Sharing
>and Security". So am I suppose to be using windows
Explorer to "grant" this
>access? Why does the "ASPNET" account not show up there?
>
>
>.
>

Re: MS Access Update Query by Paul

Paul
Fri Feb 18 08:05:08 CST 2005

On Thu, 17 Feb 2005 20:25:02 -0800, "Jim Heavey" <JimHeavey@discussions.microsoft.com> wrote:

¤ I have the following accounts which show up in XP...
¤ Administrator
¤ Creator Owner
¤ Everyone
¤ Ineternet Guest Account (IUSR)
¤ VS Developers
¤ Users
¤ System
¤ Launch IIS Account
¤
¤ Now if I go into Local Users and Groups....I see "ASPNET" account, but I can
¤ not see that account when I am using windows explorer and selecting "Sharing
¤ and Security". So am I suppose to be using windows Explorer to "grant" this
¤ access? Why does the "ASPNET" account not show up there?
¤

It's not a domain account. You have to look in the local machine accounts in the Select Users,
Computers or Groups dialog (Advanced).


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Re: MS Access Update Query by minjal

minjal
Wed Feb 23 00:24:23 CST 2005





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!