Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File Access Denied despite SHARED
Message
From
29/05/2015 17:21:02
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Web
Miscellaneous
Thread ID:
01620315
Message ID:
01620368
Views:
57
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform