>This is also interesting. From the VFP Help on TMPFILES:
>
>Specifies where temporary EDITWORK, SORTWORK, and PROGWORK work files are stored if they have not been specified with any of the other options. Because work files can become very large, specify a location with plenty of free space. For faster performance, especially in a multiuser environment, specify a fast disk (such as a local disk). Default is the startup directory.
>
>So if you can specify TMPFILES, you need not specify the other 3 if the location of TMPFILES is acceptable.

Mark,

I read this Help and it leads to the following questions:

1) Suppose I specify EditWork, SortWork and ProgWork for our main application. TMPFILES will be left default. Now, how can I determine, what are SortWork, etc. settings?

2) Which directory ALTER TABLE uses for creating its internals?

3) How much space I need on this drive?

4) I prefer to leave TMPFILES as set by user, but adjust SortWork. Would it mean, what now each index command will use this directory? If it would be a NetWork drive, how it would affect the perfomance?

You see, this is a problem, which doesn't have a simple answer, especially taking into consideration our environment.

My manager wrote me a letter: Create temp directory on a Network drive for this application. You can see, how many complications this simple proposition is led to...