>
>I was one of those who asked the question months ago and I solved the problem by putting the alias in RECNO(). However, I am plagued by 'File is in use' now and I hope your mail will help.
>
>If there is a way, this mail of yours should be posted constantly because I am sure most of the newer VFP users will face the problem. With this kind of stupid bug in VFP, I am sure people who has no strong attachment to VFP would have given it up as soon as they have started.

I just had this error occur in the past couple of days. My situation was that I was doing a replace in a local view (which of course is open exclusive). My solution was to but the following code before my replace statement:

skip  1
skip -1

and that seemed to fix the problem. I did have the error happen again, so I placed this code in a loop so that the sequence of skips and replaces could be called in a loop until the error went away. The problem seems to stem from a timing issue in VFP. One UT regular theorizes that this skip sequence somehow refreshes VFP internals.

HTH,
Peter