I inheritted an application that is installed on a computer - desktop or server - doesn't matter. That folder is then shared with Windows and multiple clients connect to it - up to 15 but usually only 3-4. The executable is about 11 megabytes and the foxpro dll's are in that folder as well. When the tables start getting over 2-3 megs each, processes in the application start to run REALLY slowly. The worst is when a view is in a dataenvironment that opens a few tables joined together.

What is the best way to deal with this besides re-writing the application to run from SQL server? Any ideas?

Randy Wessels