Wait For Connection.execute Method To Complete...

I 've coded an asp webpage where a user could toggle a boolean value through a checkbox.
When the checkbox was pressed, the page posted the toggle action to itself, a

connection.execute "UPDATE tableName SET fieldName=(Not fieldname) WHERE field_id=1

query was performed and the checkbox, after I had retrieved its new value through a recordset, changed its appearence(state). At first I used an MS Access DB and it worked fine.

After I had switched the hole application to work with MS-SQL, although I changed the above query to Code: