Record Locking

[Affliction]

Can anybody suggest a fool proof way of locking a record ?<BR>If a member of the sales team has a record displayed, no one else should be able to open that record. The asp is running on iis 4 and im using ado.