Hi
I have used the following code to update Access 97 code with no problem but
when moved it into ASP.Net as WebMethod i get "Operation must use an
updateable query"
I think it has to do with write permission but not sure how to fix it. Any
suggestion will be appreciated.
AL
code===============
loCommand = New OleDbCommand
loCommand.Connection = MyConnection
loCommand.CommandText = "UPDATE [Claim Form Table] SET ClaimCity =
'Seattle' WHERE ClaimtID = 40"
loCommand.Connection.Open()
loCommand.ExecuteNonQuery()
loCommand.Connection.Close()