Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File Access Denied despite SHARED
Message
De
29/05/2015 06:05:05
 
 
À
29/05/2015 05:20:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Web
Divers
Thread ID:
01620315
Message ID:
01620317
Vues:
64
>>Hi All,
>>
>>The app is multiuser. There is a situation that all get an automated instruction to close down after 30 seconds. When closing down, a logtable is opened, a record of the user is updated and finally it is closed. I guess that all machines try this after exactly the 30 seconds (the user can do it earlier). The table is opened with:
>>
USE 'thetable' SHARED AGAIN
No inserts are done, only 'owned' records are updated. Also no one has it opened exclusive.
>>
>>Nevertheless, some (out of let's say 100) get a File Access Denied error 1705. Is this to be anticipated behavior? What can I do best? Use a do-while?
>
>From Help on Use: "When you open a table again in another work area, the table in the new work area takes on the attributes of the table in the original work area. For example, if a table is opened for read-only or exclusive access and is opened again in another work area, the table is opened for read-only or exclusive access in the new work area." Could that be relevant here?

Nope. It is not (yet) open in the same session. It is a multi-user issue.
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform