This problem is usually caused by there not being a disk presence of the file involved.

VFP is just keeping the whole file in memory and lying to you with the DBF() command.

I think it is possible to force a disk presence somehow but I cant remember off hand.

when you do your select make sure you specify that the output is going to a table and the problem will go away.

The reason it goes away when you change SET DELETED is likly to be because you are increasing the amount of records being stored.

When VFP sees enough records for it to be worth while creating a disk presence then it will create a file.

>Hi,
> I have a problem of update cursor.
> I have issue USE DBF("mycursr") AGAIN SHARED, it work in my pc however i get error "c:\....\xxxx.tmp doexn't exist" in my colleague's pc. After couple of trying, I found that it only work in my colleague's pc if SET DELETED OFF.
> Any idea?
>
>Thank you