Hi Potter,
Funny, I ran into this same error recently under similar circumstances. You mention looking at open calls. This implies viewing more that one record at a time, yet you mention buffermode 3. Try changing the buffermode to 5 (Optimistic table buffering). And put SET MULTILOCKS ON in the BeforeOpenTables event of the DE (if a Private datasession).
>I need suggestions on where to look for my error. I am getting error 109 "record is in use by another" when no other user appears to have the table open much less the record locked.
>
>This is a service call dispatching program whose main table is called ir (incident report).
>
>All tables of form are opened in the data environment and are buffer mode 3. The most common time for the error to appear is when clicking on a button on the main form where calls are added/edited to see open calls. The button code selects the ir table and then sets the order to open. The error 109 comes on the line select ir.
>
>I am pretty sure no one else has any records locked, but am lost as to how to investigate further.
>
>Thanks
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05