Web Wiz Forums - Help Please (Operation must use an update

Print Page | Close Window

Help Please (Operation must use an update

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=5157
Printed Date: 02 April 2026 at 5:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Help Please (Operation must use an update

Posted By: UMnath
Subject: Help Please (Operation must use an update
Date Posted: 20 August 2003 at 12:38pm

I am getting an error when I try to view the forum I've just installed. The error is this:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/forum/common.asp, line 393

I have a physical path pointing to the database and my host says that the folder has read and write permissions. I've searched this forum for this error and found that it was a permissions error and that the host had to solve it. But, my host reassured me that he has set the permissions by sending me this screenshot.

http://kensingtonacademy.staging.sequoianet.com/ka_permissions_modified.gif - http://kensingtonacademy.staging.sequoianet.com/ka_permissions_modified.gif

even with this, i still get this error. I tried repairing the database, but I still have this problem.

The site is on and windows 2000 server and has ASP installed as I am currently running the login script you have on your site. The forum can be found here http://kensingtonacademy.staging.sequoianet.com/forum - http://kensingtonacademy.staging.sequoianet.com/forum

My connection to the database:

strDbPathAndName = "D:\Inetpub\wwwroot\Sequoia\kensingtonacademy.org\db\wwForum.mdb"

Any suggestions???

Thanks,

Neil

Replies:

Posted By: God_Struth
Date Posted: 20 August 2003 at 4:12pm

Try giving write permissions to the internet guest account, - _IUSR.

That error is 100% a permissions error.

Posted By: Bunce
Date Posted: 21 August 2003 at 3:24am

check the FAQ on this site.

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: UMnath
Date Posted: 21 August 2003 at 6:23am

I did try to use the FAQ's but they only said that it is a permissions problem or that the database was corrupted.

Do I have to get the host to grant permissions to the IUSR?? Right now he has global permissions set....is there a specific group that needs permissions set?

Also, the forum works until I try to login...then it pops up that error message. Everytime it errors out, I have to delete my cookies in order to not recieve it anymore.

Any more Ideas??

Thanks for you help again,

Neil

Posted By: Bunce
Date Posted: 21 August 2003 at 6:41am

Yes you need to get permissions, as it says in the FAQ!

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: UMnath
Date Posted: 21 August 2003 at 6:48am

He has the permissions set for everyone: http://kensingtonacademy.staging.sequoianet.com/ka_permissions_modified.gif - http://kensingtonacademy.staging.sequoianet.com/ka_permissions_modified.gif

My question is...should IUSR have the same permissions? or what group needs these permissions??

-Neil

Posted By: WebWiz-Bruce
Date Posted: 21 August 2003 at 6:58am

Everyone is no good, read the FAQ's it is all in their including a link to step by step instructions on how to do it.

You do have to do things for yourself sometimes in this life!!!!

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Bunce
Date Posted: 21 August 2003 at 7:35am

READ and FOLLOW this page:
http://www.webwiz.net/asp/faq/server_permissions.asp - http://www.webwiz.net/asp/faq/server_permissions.asp

Dont just skim through it.. actually READ it.

-------------
There have been many, many posts made throughout the world...
This was one of them.

Posted By: UMnath
Date Posted: 21 August 2003 at 7:47am

Thanks for your help Bunce and Borg, I sent that site link to my host so that he can set up the permissions.

I apologize for my boneheadedness.

Neil