I am using VB and ADO and have a SQL 7.0 database. I need to lock a record when ADO is in Edit mode so that no other users of the database can edit the same record. If the user puts the record in edit mode and leaves it like this for 1 hour the record must still be locked from other users on different PC's

Has anyone any ideas?