Is SET EXCLUSIVE OFF? If so, the table could be opened shared, but the DBC opened exclusive. This would cause the error you're getting.
>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?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer