I have a VBScript that needs to update a table. However, when the script executes the SQL it never completes. The script object and/or SQL are trying to lock and update the DB row at the same time. I've been told I need to 'commit' the data. I'm not a SQL expert and not sure how commit works. I'm using a simple UPDATE statement:

UPDATE Some_Table SET Some_Field WHERE Another_Field = 'Some Value'

Any advice? Thanks!