Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can anyone tell me how this is possible?
Message
 
 
À
14/11/2010 20:15:01
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01489080
Message ID:
01489082
Vues:
122
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform