Hi, Bonnie.
A couple of questions for you.

1. Is the table bound to a grid control?
2. If you don't cancel the add, but save it instead, can you cause the same error?
3. In your cancel button, what exactly do you do? A tablerevert, I imagine. If when you get the error, if you do a tablerevert on the table, what happens?
4. Are you using private or default datasessions?

I don't ever use pessimistic buffering, but since PB sets a lock as soon as editing begins and doesn't release it til the changes are committed or reversed, then I'd look at the point where I think my code is releasing my editing session.

I don't know if that helps any. :-(

>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