>Several of my users are getting an error on the 'PACK' line below. The error is 'file access is denied' as if they did not have exclusive use of the file.
>Frankly, I don't see how this can happen nor what to do about it when it does. This code , basically, has been in place since the mid 1990's first in FoxPro for DOS and now in VFP and the problem has only developed recently.
>
>If Used('TAX')
> Sele tax
> Use
>Endif
>Use tax Exclu In 0
>Select tax
>delete All For ref='DEPOSIT' And Empty(cust_id)
>Replace All tax_rate With Round(tax_rate/100,4) For tax_rate >=1.00 In tax
>Pack -- this line generates a file access denied error for several users.
>
>Thanks!
Have you tried to put this code in TRY/CATCH block?
In addition, before PACK command you can test the exclusive status with ISEXCLUSIVE function.
Also, make sure the user has access to the temp folder (set it to be local folder) and there is enough space on the disk.
If it's not broken, fix it until it is.
My Blog