Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can anyone tell me how this is possible?
Message
From
14/11/2010 21:14:33
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
14/11/2010 20:15:01
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01489080
Message ID:
01489086
Views:
101
Close the file, reopen it then do the PACK, the ALL statements lock the file headers and if caching is on can cause unpredictable results. Maybe a flush b4 the file close as well.

>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!
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform