Thanks Daniel. It was the lock in the recordset that causes the problem. I thought I should lock the record while it's being edited. I created another connection and recordset that opens the same table, that causes the "hang"
Now I just do without the lock. It is an ADO connection to a local Advantage database.