>>Well, as I said, I never set tmpfiles anymore. When I query SYS(2023) it returns C:\WINDOWS\TEMP or whatever the local windows temp dir is. Foxpro set the tmpfiles directory to the Windows temporary directory by default and has done so for a long time.
>
>David,
>
>The last statement isn't correct. FoxPro (5.0) sets the temporary files (the value returned by SYS(2023)) in whichever the default directory is (DEFAULT=) if not specified.

Not in my experience, both development and runtime. So I need to have a closer look at what's happening and why - see more remarks below.

>
>My preference is to always take the most possibilities as possible out of the "mix". As I said earlier, my experience has been that, unless otherwise specified, the tmp files will end up in the startup directory. Working, as I do, in a network environment, with a number of what, in this day and age, would be considered underpowered machines, and because my applications rely on a good deal of dynamic linking, the location of the temporary files is always specified.
>
>There's a twofold purpose behind this. First, in ensures that the throughput for queries is maximized. Since all of my summary reports are based on queries, this is important. Second, by specifying the location of these files, it has allowed me to write routines that make sure that any old files, left behind by an abnormal shutdown (GPF), can be safely removed. To this end, I wrote a post-setup executable that, among other things, writes a user specific configuration file. Included in the file is a TMPFILES= line.
>
Seems all very good practice

>It may be that tmpfiles are located in the startup directory unless otherwise specified only in the development mode and that at runtime they're located in the windows temp file directory. In testing, in development mode, the files always ended up in the startup directory and never in the windows temporary directory (as returned by the GetTempPath() API function). This may be influenced, however, by the setting of the default directory.
>
Again this doesn't happen on my system, or any other that I've tested. Weird!
All the .tmp files appear in C:\WINDOWS\TEMP (depending on the machine), both runtime and development regardless of where Foxpro fires up. Maybe your development vfp.exe is on the net?

Regards,