what i need to do is, when a record is displayed on a form and then the user wants to edit the record, i need to lock the record so no other users can edit the record at the same time. I am using the latest version of ADO.
Has anyone got some ideas for the best way to handle this situation.

Thanks
Simon