>Hi,
>
>I got the "File is in use" errors on a regular basis. What may be a reason for this?
>
>I got an error here, for example.
>
>USE (tcTable) AGAIN IN 0 ALIAS (lcAlias) SHARED ORDER TAG (tcTag)
>
>That table may be involved in havy processing by many users, but I'm trying to open it in shared mode, so why is the error?
>
>The application uses local views and the database is located on the server.
What is SET EXCLUSIVE when the above command gets run?
If you have antivirus running on the workstation and/or server, could you try disabling it for testing, or at least exclude VFP data and temp files/folders from real-time scanning?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up