database not updated

I am using an update command in my asp code that updates some rows in my
database.
Under the update command i create a recordset and ask for the rows that i
updated earlier!

Some time the rows i get are correct but sometimes the database is not
updated by the time the recordset is opened.

Is there any way to wait until the rows are updated and then open the
recordset?