>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

Kevin,

I'm not sure whether I can help you, but we can give it a try;
For about 1.5 years we struggled with the same, and only related to Citrix; after this 1.5 years the problem went away, and this was february 2001.
I just read my comments on that again (about 5 A4 pages), and there is too much involved (combined things) to give you the solution, not even being sure what caused the solution for us. So, combined things. Now in order to ty things down a little, I'd like to put a few questions. Look at the questions as if Citrix wasn't there, so "local disk" or "local tables" would mean tables residing on the PC's local harddisk when there wasn't any Citrix.

Isn't there really any situation that a table is opened Exclusively ? I mean, what about an end-of-month procedure etc. ?

Do you use Fopen on you tables, for whatever reason, and maybe only to test for whatever (i.e. 0.1 sec long).

Do you use local tables ?

Do you recognize issues on your error-routine (which cannot nest) ?

And yes (see other Message), do you recognize that something has to be done in order to let Citrix open the sufficient overall number of files; this needed a patch some two years ago.

Do you access your tables by FPDos as well ? (maybe occasionally)

Do you allow your users to have Excell etc. to access the tables ? (or, do they possibly ?)

Did you somewhere during the lifecylce of your app encounter Too many files open (or LLF4 error) ?

Does your Citrix configuration allow for the access of the PC's normal C:-drive ?

Are you 100 % sure that the File access denied is about a table ?

Didn't you proove by accident that a user can get the error while being the only one in the app ?


Note : None of any single "yes" will lead to the solution (maybe except from the patch for Citrix).