>>So what happens when a user has made all his or her updates just to be told "We are sorry but the record you are trying to edit is locked"
Actually, this is not the way it works. When a user reads a record for editing, the record is locked until he updates. During that time, when another user wants to open and lock the same record, for the same purpose, THEN he will get the message "sorry, this record is locked", BEFORE he edits the record, not after. So for him, there is no time waisted, it's just the time for a coffee break ;-) -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4