>Multi-user VFP 6 app that utilizes about 100 different tables.
>
>One of our installations has about 20 users who access the server application through Citrix, and another 20 who access the same app (and databases) through the LAN.
>
>Our app ALWAYS opens tables with EXCLUSIVE OFF...there is never an instance where a file is open EXCLUSIVELY.
>
>Unfortunately, we've had several instances where users are getting FILE ACCESS DENIED messages when the app tries to open a file. Some weeks it's file 'ABC'...other weeks it's file 'XYZ.' It has the users very frustrated and me pulling my hair out.
>
>Can anyone think of any instance where VFP would fire the FILE ACCESS DENIED message, even though other users are never opening the same file exclusively? It just 'seems' that Citrix may be having a connection or authentication issue, but we can't pinpoint where.
>
>Thanks,

Kevin,
If using views, VFP opens the DBC exclusively for a split second when you open a view. You could conceivably get the access denied error in these situations.

You could institute an error trap either using ON ERROR on in an object's Error event. The object could open your your specified tables in a specified datasession and return success or failure. If an error took place, you could retry, if applicable.

HTH.