I will have multiple user accessing a database at one time. If a user is editing a record, and another user happens to select the same record to edit, is theire a way to flag user #2 that the record is currently being edited and not allow him acccess at that time? Kinda of a freezing of the record, or readonly of the record.

Any ideas?