I'm using VB6 and SQL7 with ADO code to connect to the database. What is the best way to check if a record is already in use. So that two people cannot amend (open) the same record is any given table?