I have an access database which I access through VB6

how can I lock a record??

(I do not want to edit straight away)

and do I just check for an error or can I interegate the database to see if it is locked (can I say who locked it).

Thanks

John Murphy