In a CONFIG.FPW you can specify where to create temp files.
TMPFILES=C:\Temp
EDITWORK=C:\Temp
SORTWORK=C:\Temp
PROGWORK=C:\Temp
See VFP help on Config files for what each of these means.
>Hi everybody,
>
>I need to understand, where Fox tries to create temp files during INDEX ON and ALTER TABLE commands on huge tables. I was thinking, it uses current place for temp files, but it seems, like it uses current location of databases instead.
>
>I'd like to check for available space before running ALTER TABLE / INDEX ON command, and I need to know, how many space I need and where.
>
>My second question is: can we re-direct temp files to the specific location for the specific application (this application is run under another main application). If yes, how?
>
>Thanks a lot in advance.
Mark McCasland
Midlothian, TX USA