Server Erroe: Operation must use an updateable query.

[mchoudhury]

Hi Guys,
I doing this testing with an Access db. I'm trying to insert some data into access db through vb.net. But i keep on getting thie error:
Server Error: Operation must use an updateable query.

I know its something to do with permission issue. Where the db is that web folder has no read only selected.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
LoadData()
End Sub

Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("db1.mdb")
Dim cmd As New OleDbCommand("INSERT INTO Customers (FirstName, LastName)VALUES('" & txtFirstName.Text & "','" & txtLastName.Text & "')", New OleDbConnection(strConn))
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()
LoadData()
End Sub

Sub LoadData()
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("db1.mdb")
Dim strSQL As String = "Select * From Customers"
Dim cmd As New OleDbCommand(strSQL, New OleDbConnection(strConn))
cmd.Connection.Open()
Repeater1.DataSource = cmd.ExecuteReader
Repeater1.DataBind()
cmd.Connection.Close()
cmd.Connection.Dispose()
End Sub

The error is shown on the cmd.ExecuteNonQuery() part.

Thanks