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'). 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()

 

[Guest]

It could be a permission problem!
Make sure u have full right to the MDB file or the Directory!
GDLUCK

 

[Guest]

HI John,
It could be a permission problem.
Make sure u have FULL right on the MDB file or the Directory!
Or u could close ur Access before running the page
GDLUCK

 

[John]

I have right clicked on app folder under 'my default web' under 'Internet
Information Services', selected 'Permissions Wizard' and given the default
permissions. Still no luck. What else can I try? The machine is win xp pro.

Thanks

Regards

It could be a permission problem!
Make sure u have full right to the MDB file or the Directory!
GDLUCK

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'). 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()

 

[Hans Kesting]

I have right clicked on app folder under 'my default web' under
'Internet Information Services', selected 'Permissions Wizard' and
given the default permissions. Still no luck. What else can I try?
The machine is win xp pro.

Thanks

Regards

You have to set permissions on the file system, not (just) IIS.
At least the mdb file must be writable for the aspnet-user,
(the account the aspnet process runs under)
maybe the directory also.

Hans Kesting