>>Sounds like Dan has got you going in the right direction. First problem to solve is that you must stop the user from turning off the pc.
>>
>
>I have had so many problems with users turning off the PC or just leaving the apps opened and going to lunch. Barbara Paltiel had suggested using Semaphore locking, but I never had time to really research that.

I know what you mean. My main app doesn't buffer. User click an edit button to lock a record and then a save button to unlock it. Because it is healthcare record we wanted to make sure only one person can change the record at a time and there were no overwrites. Sure can cause some problems on occassion.

I have implemented another smaller (no health data) that using buffer with optimistic record locking. Was surprisingly easy to implement especially since I used a "last one wins" strategy.