Sure, the .dbf is very little and the .fpt is over 100Mb. But shouldn't VFP also check the lockstatus of the .fpt besides the status of the .dbf before deciding that it's okay to use it?!
>No, Reprocess works for VFP locking only. If a .DBF is locked by some outside process, you'll get 'Access denied' or 'File in use' error immidiately on USE. My guess is that in your case .FPT is much bigger than .DBF so you most likely get errror on .FPT than .DBF.
>
>>USE reacts well during copying of myTable.DBF, because it discovers that some other process is currently locking myTable.DBF. SET REPROCESS defines the behavior in that case. But when USE finds out that myTable.DBF is not locked, it will open it, only to find out a tiny bit later that myTable.FPT (or CDX too?) is locked. And then, instead of doing what it would have done if myTable.DBF was locked, it will generate the error 'Memo file is missing or invalid'.
>>
>>What's your insight?
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.