>I'm currently developping an application with Visual Basic 5.0 and SQL Server 6.5.
>I would like to know how to lock a record when a user is editing it, to prevent other
>user to edit the same record.

Check your locking settings for the type of cursor that you have chosen. If you choose Pessimistic locking, it will lock the record while editing.