I am writing a small web-based data entry system in ASP that is utilizing a SQL 7 database. It will be used by multiple users. I am not exactly sure how to lock a record. If the record is locked, I would like to display a message to the user that the reocord is currently being updated by another user and cannot be updated. How do I do this? Is there a place where sample code can be found?