Ria,

If a workstation using the file stops responding or GPFs, the files used may get locked. If this is on a Novell server, the admin needs to clear that workstation. Then only the other users will be able to access that file.

Check the "exclusive" setting. If it is on, the USE command will try to open the files exclusively. Better to always have the USE command with SHARED keyword.

HTH,
Hitendra

>You have attempted a USE, DELETE, or RENAME command on a file that is being used by another user on a network.
>
>Hi,
>
>We have an application that has been in use for a long time. But in this week, users reported this error on some days and once a user gets this error, the application becomes non usable to all other users.
>
>It is a read only application, that just displays inormation to users and there are no edit/add methods here. All users query data that is on the server.
>
>- The program does not open any of these tables exclusively
>- There are places in the code where 'USe' command is sometimes issued on these tables if they are open.
>- Select queries are performed on these tables
>
>What could be the cause of the error here?
>Any help would be appreciated.
>
>Ria