1. suppose i have to lock a set of records from vb ?how do i do it ?should i use xlock,rowlock or any other method is there? 2. how do i get the name of the user who has locked a particular record in multiuser environment?