Updating Access DB

[tauhidt]

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

[Patch21]

You code looks fine, it sounds like a write permission error.

Try making sure that your .mdb file is not readonly, and make sure the user has write access to the folder it is in.

Try googling the error before you post here, as these errors are very common and there is almost always a solution somewhere on the web.

[tauhidt]

Yep, I looked on google and it is a permission error. I need to give the 'Everyone' user write access to the file.