Ria,
You are probably running with SET EXCLUSIVE ON, this is preventing you from being able to open any tables that are in use by another user, then you'll get the second errors because the table didn't get opened. Make sure SET EXCLUSIVE is OFF and it's scroped to the data session so private DS forms will have to have this set in their Load().
>I have a program that is giving error like 'File Access Denied' & 'No table is open in
>the current workarea' when used ina multiuser environment.
>
>This program just allows the user to view the data and does not allow them to make any
>changes to it.The program uses data that resides on the server, but since there is no
>provision to change the data, no where in the code, are any of the tables opened
>exclusively.
>
>In all cases, the program extracts the required data as per the query into tables
>that reside locally ans these tables are opened exclusively.
>
>Is there anything that I specially need to look out for in the code? Any help would
>be appreciated.