>G:\calprod\
>is the current working directory and where the EXE is running.
>
>An error "file does not exist" appears on PACK command below. The file exist when the USE is done, but is missing (deleted from disk) on PACK. When I checked in g:\dbase\, MyTable is really not there. But a TMP file has been created in the g:\calprod\. I understand that PACK create a TMP file and command is not completed until VFP rename the TMP to DBF. My question is:
>WHAT's WRONG WITH THE PACK? WHAT ARE THE REASONS A PACK FAILED?
>
>SELECT A
>USE g:\dbase\MyTable EXCLUSIVE
>DELETE FOR id > 10000
>PACK

Also I don't think it's a good idea to have TEMP directory on the network drive.

And I don't use SELECT A. Should be select 0, though this is a minor point.