after Deploying webapplication Error" Operation must use an updateable query. "

Question

User-2074802862 posted

hi

actually lots of hour i spend on this problem to solve

if any bady has solution plz late me know

the problem is webapplication running fine befor i deployed it but after deploying evry thin work expt insert and update command

here is the problem

Operation must use an updateable query.

 

          
cmd = New OleDbCommand("insert into NewApplicationForm (csName, Cname, Nature, LOS, Post, Nationality, PPno, Salary, Pmode, BName, PPCopy, VScopy, IDcopy,NYC,Climit,OutS,LPnODC,CCstmt,CCcopy,Age,Altno,PPnVSvalidn,DOP,Aname,Verified,Status,Card,DOC,cComment) values ('" & txtName.Text & "','" & txtcompany.Text & "','" & txtnature.Text & "','" & txtlos.Text & "','" & txtpost.Text & "','" & dlNationality.SelectedItem.Text & "','" & txtpp.Text & "','" & txtsal.Text & "','" & dlpaymode.SelectedItem.Text & "','" & txtbank.Text & "','" & (Chkppc.Checked).ToString & "','" & (chkvs.Checked).ToString & "','" & (chkid.Checked).ToString & "','" & (chkbankstmt.Checked).ToString & "','" & (chkVnIdverify.Checked).ToString & "','" & dlUAE.SelectedItem.Text & "','" & txtccname.Text & "','" & txtccusing.Text & "','" & txtcclimit.Text & "','" & txtoutstand.Text & "','" & (chklate.Checked).ToString & "','" & (chkccstmt.Checked).ToString & "','" & (chkcccopy.Checked).ToString & "','" & txtage.Text & "','" & txtaltno.Text & "','" & (chkppnv.Checked).ToString & "','" & txtdop.Text & "','" & (Label2.Text) & "','" & dlstatus.SelectedItem.Text & "','" & dlstatus.SelectedItem.Text & "','" & dlcardtype.SelectedItem.Text & "','" & Date.Now() & "','" & txtcoment.Text & "')", cn)
        cmd.ExecuteNonQuery()

Answer 1

User-1659704165 posted

Hi,

http://forums.asp.net/t/154273.aspx

http://support.microsoft.com/kb/830977

Check The above Link,
It seems The problem of Permissions

Hope It helps

Answer 2

User-1199946673 posted

Solving the "Operation must use an updateable query" error

And after you resolved this error, i suggest you read another article of Mike:

Parameter Queries in ASP.NET with MS Access

Answer 3

User-821857111 posted

A tip for the future - copy and paste your error messages into Google.  This error in particular must get posted to forums and newsgroups many times a week, and certainly almost daily here.

I don't want to discourage you from asking questions at all, but you would have saved the "lots of hours" you spent on the problem, plus the time you waited for your post to be moderated.

[:D]