Access Databases and AccessDataSource Control

Re: FIX: Operation must use an updateable query error when using Access db

sirdneo — Tue, 30 Jun 2009 14:33:15 GMT

    1- Right Click on FOlder where mdb file is placed and Select Properties
   2- Goto Security Tab
   3- Click Add, then click Location.
   4- Select your pc name, usually first item.
   5- Press Ok, then press advance and then Find Now.
   6- Select ASP.NET user if not exist then select Authenticated Users.
   7- Press Ok. And Select Read/Write/Modify/List FOlder

8- Also make sure mdb file is not read only.

Re: FIX: Operation must use an updateable query error when using Access db

shabirhakim1 — Fri, 19 Jun 2009 13:26:34 GMT

This error USUALLY occurs when you attempts to perform an UPDATE or some other action that alters the information in the database.

This error occurs because dataobjects what ever ado or ado.net is unable to write to the Microsoft Access database due to insufficient write/modify permissions, which can be easily fixed by granting read/write to IUSR_<machineName> and IWAM_<machineName>.

IUSR_<machineName> and IWAM_<machineName> come into focus when an anonymous web user needs to modify the Microsoft Access database & while doing so Jet creates an .ldb file to handle database locking. If the above mentioned 2 users don't have the necessary permissions, the lock file isn't created & ultimately the Microsoft Access database can't be modified..

To fix this problem, right click on the folder which holds the Microsoft Access database & choose properties. Use the Security tab in Explorer to adjust the properties for this folder so that the Internet Guest account has the correct writable permissions.

Also make sure that the MDB file itself isn't marked as read-only, and that you don't have the MDB file open; particularly in exclusive mode; while trying to reach the Microsoft Access database from ASP

Regards

shabir hakim

Re: FIX: Operation must use an updateable query error when using Access db

Sayre — Fri, 12 Jun 2009 01:50:37 GMT

Hi,

try to right click your access file then uncheck the checkbox if the Read-Only are checked. I think this error result because of the permission.

Re: FIX: Operation must use an updateable query error when using Access db

mryogi76 — Mon, 05 Jan 2009 13:17:16 GMT

I have set Full permission to IUSER as well as Everyone for the folder containing mdb, which is App_data. But it doesn't work for me. I still get - "Operation must use an updateable query."

Re: FIX: Operation must use an updateable query error when using Access db

slimx3m — Fri, 21 Nov 2008 22:47:42 GMT

thnx for this info. after have my web running locally and then uploading it to my server i had this error and i was able to fix it right-away

Re: FIX: Operation must use an updateable query error when using Access db

shahid_gomalian — Sat, 08 Nov 2008 05:21:46 GMT

I also had the same problem. But by the Grass of Allah i solved it with only a single click if u like, try it :

"Right click on the folder containing your access database then go to properties-security tab, select everyone group and give it write permissions". check it out

Re: FIX: Operation must use an updateable query error when using Access db

pkmnambiar — Wed, 29 Oct 2008 11:01:45 GMT

The problem is not with the code...

Go to Control Panel >> Administrative Tools >> Computer Management >>>>Services and application >>IIS there right click on the folder containing data base goto properties, then tick on the check box READ and WRITE. After that restart IIS. NOW THE PROBLEM IS SOLVED(No need to go for FAT file system)

Re: FIX: Operation must use an updateable query error when using Access db

pkmnambiar — Wed, 29 Oct 2008 11:00:08 GMT

Re: FIX: Operation must use an updateable query error when using Access db

pkmnambiar — Wed, 29 Oct 2008 10:57:17 GMT

Go to Control Panel >> Administrative Tools >> Computer Management >>>>Services and application >>IIS there right click on the folder containg data base and tick on the check box READ and WRITE.

After that restart IIS.

NOW THE PROBLEM IS SOLVED(No need to go for FAT file system)

Re: FIX: Operation must use an updateable query error when using Access db

Mikesdotnetting — Sat, 11 Oct 2008 10:19:32 GMT

pradeepavadhani:
Operation must use an updateable query.
/webreg/Update1.asp, line 10

You are using classic ASP (pages end in .asp) whereas this forum covers ASP.NET (pages end in .aspx). They are completely different. In your case, you need to apply MODIFY permissions to the IUSR_yourmachinename account to the E:\Inetpub\wwwroot\WebReg folder. That should solve the problem.

Re: FIX: Operation must use an updateable query error when using Access db

pradeepavadhani — Sat, 11 Oct 2008 04:42:52 GMT

Hi All,

I need really help from you guys.

My code is as follows..

<%
dim con
set con = server.createobject("adodb.connection")
dim rsdesig
set rsdesig = server.createobject("adodb.recordset")
dim str
con.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=E:\Inetpub\wwwroot\WebReg\webreg.mdb"
str="insert into webreg(AgntName,MmbrSName,mbraccount,orderStatus,DDate)values('" & request.form("AgntName") & "','" & request.form("MmbrSName") &"','" & request.form("mbraccount") & "','" & request.form("orderStatus") &"','" & request.form("hdnSysdate") & "')"
Response.Write str
con.Execute str
Response.Redirect "update.asp"
%>

Once i submit the data from the main page i get this error

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/webreg/Update1.asp, line 10

I have checked all possible steps that you all said previously but still i get this message

Kindly help me the work i am doing is very critical.

Thanks in advance.
Pradeep

Re: FIX: Operation must use an updateable query error when using Access db

vigraman — Wed, 20 Aug 2008 18:13:22 GMT

Thank u very much

Regards vigraman (India)

Re: FIX: Operation must use an updateable query error when using Access db

gorla.naveen — Thu, 13 Mar 2008 09:22:18 GMT

Hi Henrix,

this is naveen

Query = "insert into PlayerInfo (Name,Email,CharacterName) values ('" & NameBox.Text '," & MailBox.text & "','" & CNameBax.text & "')"

in tha above query u missed the single quatation near mailbox.text keep the quatation and try it once

Re: FIX: Operation must use an updateable query error when using Access db

Rkiser1958 — Wed, 30 Jan 2008 15:01:56 GMT

I was sure it was on the Server side, and I finally got someone to fix it.

Thanks

Re: FIX: Operation must use an updateable query error when using Access db

Mikesdotnetting — Wed, 30 Jan 2008 07:27:56 GMT

Rkiser1958:
I am having the same problem except my code works fine on my computer using IIS, now that I have it on the web using a Web Hosting service (on a windows server) all of the "search" commands work but when I try to insert data I get the error:
Server Error in '/' Application.

Operation must use an updateable query.

and one of the lines in my code is highlighted

"SqlDataSource1.insert()" it says SqlDataSource but it is configured using an Access Data source.

Like I said it works fine on my computer when I created a virtual directory using IIS.

Now is the problem with my code or on the server side.

If you had read through the posts in this thread, you would have found that the cause of the error is insufficient permissions. On WinXP, the ASPNET account needs Modify permissions on the folder containing the database file. On Win 2k3, it's the NETWORK SERVICE account.