Access Security Issue

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

Guest

I get the following error message when I attempt to called query which
resides in my Access DB (Stored procedure), "Operation must use an updateable
query". I looked at the KB article which addresses this error and it
indicates that I need to change the security on the folder and the file which
contains my access Db. I went into the folder and and the file and change
the "IUSR" account to "Full access". But this did not resolve the issue.

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?

Any ideas as to what else I should look at so that I can do an update on the
Access DB?

Thanks in advance for your assistance!!!
 
Jim,

Assuming we are talking asp.net here, you should grant privileges to aspnet
account (winxp, 2k) or network service (win2k3).
 
¤ I get the following error message when I attempt to called query which
¤ resides in my Access DB (Stored procedure), "Operation must use an updateable
¤ query". I looked at the KB article which addresses this error and it
¤ indicates that I need to change the security on the folder and the file which
¤ contains my access Db. I went into the folder and and the file and change
¤ the "IUSR" account to "Full access". But this did not resolve the issue.
¤
¤ 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?
¤
¤ Any ideas as to what else I should look at so that I can do an update on the
¤ Access DB?

If this is an ASP.NET app, the IUSR account requires access only if you're using Anonymous (no)
authentication with impersonation enabled.

Otherwise, if impersonation is not enabled, the app runs under the identities specified by Miha


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top