Nadya the response is bellow the questions.
>Hi everybody,
>
>Seems like my first question led to a dead end :(
>
>Also I'm not convinced, that ALTER TABLE command creates temp files in TMPFILES directory (specified in config.fpw). The error message, I got, indicated, that it was trying to create temp file on the network drive.
>
>INDEX ON command seems to put their internals under SORTWORK path according to Help file.
IF you don't supply SORTWORK EDITWORK AND PROGWORK Then TMPFILES isused.
>
>I have a problem. I need to run ALTER TABLE and INDEX ON commands on huge VFP tables (about 5mln. recs). I want to check for free space prior to running these commands.
>
>So, where should I check for the free space?
SYS(2023)

>
>How much space would I need?
you may need the double of the space.
>
>How can I re-direct VFP internal temp files to some temp directory and then re-direct it back?
You can't
>
>Can somebody from MS help me with these questions?
>
> Some specifics about our environment:
>
> We're running .app applications from the Network drive. All databases reside on the same Network drive. Each user has VFP installed. Main application, called JobControl, calls all other applications.