Operation must use an updateable query?
Jeg får denne fejl:Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
Min kode:
Dim strConn As String
Dim strSQL As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & HttpContext.Current.Server.MapPath("db/Data.mdb")
strSQL = "INSERT INTO tblNews (SubmitDate, Title, BodyText) VALUES ('" & strDate & "', '" & strTitle & "', '" & strBody & "')"
Dim objConn As New OleDbConnection(strConn)
Dim objCmd As New OleDbCommand(strSQL, objConn)
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()
Nogen der kan se hvad der er galt?
