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