Hey,

I'm having quite a bit of trouble updating an access database from withing ASP.net using VB.net.

I tried this simple query to update the database:
DBConnection.Open()
Dim dbCommand1 As New OleDbCommand("UPDATE DST_Users SET UserPW='" & newPassword & "' WHERE Username='" & in_username & "'", DBConnection)

dbCommand1.ExecuteNonQuery() 'causes an error at this line
DBConnection.Close()

The error is: Operation must use an updateable query

How do i fix the problem?

Thanks