Hi Farouk,
If this problem is still actual....
A while ago I had a similar problem - sort of "dead lock".
I use SPT , not views. It's a shame for me to say that, but I forgot to put COMMIT transaction in one of my method, which was the reason for the lock. May be you forgot something like this ?
You may also try to run you queries with LOCK HINT

Select * from myTable with (nolock)
Update myTable with (rowlock) set myField=""

Try to do this, see if it helps

Mariam

>Hi all,
>
>I have the above scenario when user A opened form and add a new txn record for the form and saved... User B opened same form and viewing the same record and the app will freezed on user B until user A logout from the app.
>
>From the SQLServer Enterprise Manager, I can see User A has caused a lock on User B on a particular view. This supporting view was requeried in the form refresh method and tableupdate in the saving.
>
>If I move the requery from the refresh method of the form and just b4 and I saved the record (to make sure no same record existense), the lock will not happen... Why?
>
>Regards,
>Farouk Yew