[RESOLVED] Updated data is not showing using sql update query

[si_the_geek]

Hi si_the_geek

Sorry for misspelling of your name

No worries, you aren't the first

However, is there any way to set locktype in my previous LoadDatabase.Execute("Sql query")?

No.

I am seeking that because I have to recode the whole program using rsData.Open system.

I don't see why... the recordset still has the same methods etc, all you should need to change is a few lines in cmdUpdate_Click (from the Update SQL statement you had originally to the code in your previous post).