Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File Access Denied despite SHARED
Message
De
29/05/2015 17:21:02
 
 
À
29/05/2015 04:53:30
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:
01620368
Vues:
58
>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?

If you have a "logged in" table with each process holding a lock on its own record, you could try to use this table to que the access to the log table. Or send the automated shutdown to the next machine AFTER the log is written and the RLOCK on the login record is released.

Had something similar in the routines preparing for schema changes to backend tables with an app of a couple of hundred tables...
Also used status fields in the login table:
first block all unlocked logins
loop
  send takedown notices
update
unblock login table
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform