Cetin,
I only have one form running. It happens after doing an add & cancel several times on the same form.

>Bonnie,
>They're both scoped to current data session. Might that be the problem ?
>Cetin
>>Thanks for the reply, Cetin. I already have SET EXCLUSIVE OFF and SET MULTILOCKS ON. This app is written for multi-user use, I'm just the only one on right now because I'm attempting to debug this problem.
>>
>>Bonnie
>>
>>>>Hi folks! Got another weird one! I'm getting Error #108, "File is in use by another". What the docs tell me is that this error is generated by an attempt to "USE, RENAME or DELETE" a file that is being used by another user on the network. Well, that isn't the case here ... I'm the only one working on this.
>>>>
>>>>It's an intermittent error, it seems to be happening on a permanent table, not a cursor, and it's happening when I attempt to INSERT INTO. From the command window I also tried an APPEND and got the same error. But, when I USE'd it to close it and USE'd it again to open it back up, no problem, the error wasn't generated. I'm using Pessimistic Row buffering (so there's no table-locking or file-locking that I'm aware of).
>>>>
>>>>It happens when I attempt my "add" code on my form more than a few times (I hit the "Add" button, then "Cancel" it and do this a few times and then the error finally fires).
>>>>
>>>>Any ideas?
>>>>
>>>>TIA,
>>>>Bonnie
>>>set exclusive off
>>>set multilocks on
>>>
>>>Even a single user needs shared access at times.
>>>Cetin