Is there anybody know how to do the record/row level locking instead of
page-locking? Could you pls provide some sample code of how to do it?

My case is when I am doing update table, I don't want to lock the whole
table/page, because I need other persons have the access to read the
other records in the same table.

If it's possible, could you pls tell me how to do it in VB?

Thanks a lot.