I do the follwoing in my code when I open tables:

"use RETURNS.dbf again in 0 shared"

I do this so that all of the tables are open when someone is using the APP. This way every user gets a separate instance of the table to do their thing. My systems folks are telling me that this is not good for the server. At this point, I have 12 tables open multipied by 8 users for a total of 96 tables open while they are in the APP on the server. The IT guys tell me that there are 37 files open per person. The DBC and EXE are in this number which would increase my number to 14 files per person or a totla of 112. This still should not grind my server to a stand still. The Server has two P3-600 processors, 384 MB DRAM, 4 18.2GB SCSI hard drives. All was fine until they tried to install some virus software on there that I never heard of and crashed the thing.

My question is, is there a better way to open tables? Are there files running that I don't know about? How can I better manage memory?