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.

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?

How much space would I need?

How can I re-direct VFP internal temp files to some temp directory and then re-direct it back?

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.