Thank u very much

 

Regards vigraman (India) 

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

 

 

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.

 

 

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)

 

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)

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)

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

 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

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."

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.

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

    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.