jonyzz

Hello everyone. I am hoping to find an answer for a specific question. I have an ASP project - a pharmacy web-site with an MS Access database, you can register, login, put some goods in your shopping basket, logout... etc. I have a problem with the database - 'operation must use updateable query' - this error is everywhere I use the INSERT statement. I suppose the database is locked or something like this?? I thought that the problem might be in the version of MS Access on my PC - I have Office 2003, but the database was made on an earlier version of Access.
If any of you will be able to help, I will be glad.
10x

Infinite Recursion

Out of curiousity... are the privileges set correctly on the database to where the "service account" has the authority to use the INSERT command?

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

jonyzz

Hello, Infinite Recursion, thank you for your question, I just have to confess I didn't quite understand it. I am a noob and I don't know how to set the privileges on the database (is it from Access itself, or in the project with the APS code?).
Meanwhile I got some more info. As this project is not on my PC I wasn't able to write down much:
the exact error is:
"Microsoft JET Database Engine (0x80004005) operation must use updateable query"

I still don't know anything but: Microsoft.Jet.OLEDB.4.0

I will try to explain later more about the error.
And I don't figure out these number: 0x80004005 - is it an error code

Infinite Recursion

My experience is mostly in MySQL, so by setting priveleges I was refererring to GRANTing the userid SELECT and INSERT into the database table. I'm not sure if Access has an equivalent.

Try this:



Issue

The following error: 80004005 – Operation must use an updateable query – occurs on a page when an event is updating or inserting into a recordset.




Solution

There are several things that may cause this error. Many of the possible reasons are listed in the table below.


The permissions that are set on the directory the database is in. IUSR privileges must be set to "read/write".


The permissions on the database itself do not have full read/write privileges in effect.


This error can also occur when the database is located outside of the inetpub/wwwroot directory. Though the information is still able to be viewed and searched, it cannot be updated unless it is in the wwwroot directory.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

paulchwd

I had the same problem. Most likely this is the problem: there is an account bulit into windows called internet guest account iuser. It is used to perform write operations on a database, and thus needs to have sufficient acces to the place where the database is located.

i can give you the solution if you can tell me what version of windows you have

paulchwd

ok. assuming you have windows xp see the attacehd file (for word)

Attached Files

Setting iUser Permissions.doc (21.5 KB, 29 views)

jonyzz

yes you are right paulchwd, I have WindowsXP
I saw your answer a little too late
I will check the document. 10x