Explanation:-
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