Operation must use an updateable query.

[John]

Hi

I am getting [OleDbException (0x80004005): Operation must use an updateable
query.] error on ExecuteNonQuery() . Full code is given below. The values I
have given are; ('trtrt', 'retret', '1/1/2', '333'). The application is an
asp.net webform. Any idea what is the problem?

Thanks

Regards

Dim sSQL As String = "INSERT into Applications (forenames, surname, dob,
[number]) " & _
"VALUES ('" & txtForenames.Text & "', '" & txtSurname.Text & "', '" &
txtDOB.Text & "', '" & txtNumber.Text & "')"
' Response.Write(sSQL)
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("/") + "Staff_Application/Staff_Application.mdb" & ";"
Dim MyConn As New OleDbConnection(strConn)
Dim cmd As New OleDbCommand(sSQL, MyConn)
MyConn.Open()
cmd.ExecuteNonQuery() '<=== This line gives the error.
MyConn.Close()

 

[W.G. Ryan eMVP]

Other than Dynamic SQL (which is a disaster waiting to happen with a Web App
[and any other for that matter]) - my first guess is make sure you can write
to the db. See if you can do a simple update instead of an insert - I'm
guessing it's probably a permissioning issue and you can't write to it.

Let me know if not.

Cheers,

Bill

 

[Val Mazur]

Hi John,

It looks like a permissions issue. Check next KB about it

http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

 

[kapsshaw]

Hi

I am getting [OleDbException (0x80004005): Operation must use an updateable
query.] error on ExecuteNonQuery() . Full code is given below. The values I
have given are; ('trtrt', 'retret', '1/1/2', '333'). The application is an
asp.net webform. Any idea what is the problem?

Thanks

Regards

Dim sSQL As String = "INSERT into Applications (forenames, surname, dob,
[number]) " & _
"VALUES ('" & txtForenames.Text & "', '" & txtSurname.Text & "', '" &
txtDOB.Text & "', '" & txtNumber.Text & "')"
' Response.Write(sSQL)
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("/") + "Staff_Application/Staff_Application.mdb" & ";"
Dim MyConn As New OleDbConnection(strConn)
Dim cmd As New OleDbCommand(sSQL, MyConn)
MyConn.Open()
cmd.ExecuteNonQuery() '<=== This line gives the error.
MyConn.Close()

User submitted from AEWNET (http://www.aewnet.com/)

 

[Teemu Keiski]

Hi,

check this post at ASP.NET Forums

FIX: Operation must use an updateable query - error when using Access db
http://forums.asp.net/154273/ShowPost.aspx