MS Access Update Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
Hi Jim,

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

HTH,

Elton Wang
(e-mail address removed)
 
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?
 
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
 
¤ 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top