INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

ASP MS Access Operation must use an updateable query

ASP MS Access Operation must use an updateable query

(OP)
Hello.

I have problem with an .ASP page that can not update a Microsoft Access Database. I get this error.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/in/disser/registration/savedissertation.asp, line 79

The strange thing is that if I grant modify permissions to my windows account on the "database" folder which contains the .mdb file then I can write in the database without problem.

But, if I grant modify permissions to the Internet Guest account on the same folder I see the above error message.

The same ASP script was working without problems in the recent past but suddendly in the last week this strange problem is occuring.

The Internet Guest account is not working anymore even with Full Control permissions.

Any ideas what is causing this problem?

Thank you in advance.

Stergios

RE: ASP MS Access Operation must use an updateable query

(OP)
I forgot to mention that I am hosting the ASP application on a Windows Server 2003 with IIS 6.0.

Stergios

RE: ASP MS Access Operation must use an updateable query

Are you sure you have anonymous access turned on for the IUSER_machinename account in IIS6 for this site?

RE: ASP MS Access Operation must use an updateable query

(OP)
I figured out that if the ASP code and the database is stored in a folder that is accessed via "Basic Authentication" then the Internet Guest account is not working.

If I place the code in a folder without any authentication then the Internet Guest account it works.

The basic authentication causes something that prohibits the Internet Guest account from operating.

RE: ASP MS Access Operation must use an updateable query

I'm not a sys admin and this may not be the right way to fix the problem but it may work.

If your access database is called fred.mdb, from the cmd line on the server, type

CODE

cacls fred.mdb /E /G everyone:c 
That should give everyone change access to the file.

RE: ASP MS Access Operation must use an updateable query

I guess choosing "Basic Authentication" disables "Anonymous Access" .... which of course makes sense, but the interface in IIS6 is confusing because both can be checked. I think in IIS7 you have to disable Anonymous authentication before you can choose basic or windows authentication

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close