>Hi,
>Sorry, this is a long post but I need help.
>
>I need a lot of help tuning a windows 2000 server SP3 for VFP 6 use. My client is running AccountMate LAN 505 and several of my custom programs. Both AccountMate and my programs are experiencing “file is use by another” errors. It does not matter how many users – two users can cause the error. AccountMate has over 120,000 users (most using FoxPro DBC) and the error is not reported. I have my custom programs in use at one location with 15 users all pounding on it at the same time. I don’t even use the same DBC or tablesas AccountMate. So at this point I don’t believe the issue is about either AccountMate or my programming. BTW when using AccountMate programs my custom programs are not running. The only thing left is the environment which follows:
>
>It is a mixed environment of Novell and Windows. The clients workstations are windows 98 and windows 2000. The Novell has two servers, one to support logins, email, etc. and the other as a file server (has several old FoxPro 5 programs running fine). There are two servers that have Citrix running (I believe the OS is Novell). One server with Windows 2K has terminal service running and is hosting the AccountMate and my custom programs. The LAN is 100T Full duplex and appears healthy at least according to a FLUKE meter (less than 1% collisions). Most of the clients are using IP but there are a few using IPX as the primary protocol.
>
>I have turned off oplocks on two client computers and the Win 2K server (oplocks is already turned off on the Novell box). Testing has not proved successful. So what is next?
>
>In my programs I’m using both buffering modes 3 and 5 along with begin transactions. It appears that AccountMate is doing the same thing

First make sure that antivirus isn't an issue. Then take a look at:

http://support.microsoft.com/default.aspx?kbid=818528
http://support.microsoft.com/default.aspx?scid=kb;en-us;299603

HTH.