Locking a record from MsAccess

[inspect]

I have asked this one before, but due to my lack of knowledge in SQL I don’t think I made it very clear. I have a database that has been converted to a front-end (Access2000) and a Backend (SQL7). The program is designed for multi-users, and may have different users attempting to access the same record at the same time. There is a separate form for each department to use to update the data in differant fields of the same table. Before converting the program to use SQL the program would not allow edits (even the attempt to edit) on a record that was already being edited. Now the user is able to access the record and enter data only to be told that the record can’t be saved due to another user’s editing. I need the record to lock in a way that will tell the user that they don't have editing access. The process needs to allow the viewing of the record but not allow the second user to begin editing. I am new to SQL and limited in Visual Basics programming.