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