>>OK, the application is working pretty good, it's time to start optimizing it's performance.
>>
>>What are the standards for TMPFILES when working with VFP databases on a network.
>>
>>Our user base is widely varied.
>>
>>I'm assuming I want to use the windows temporary directory.
>>
>>Also what is the API call to get the windows temporary directory?
>>
>>And lastly, TMPFILES in the help file say's it takes a DRIVE:, does it take a path also? (C:\TEMP?)
>>
>>Any help appreciated.
>>
>>Eugene Henderson
>
>
>By default, VFP 6.0 will send temp files to the Windows temp directory.

No true, Craig. By default, VFP6 puts its temp files in the starting directory for the application. This can be overridden by setting the registry value through the Tool-Options-Files dialog for the development version, but this setting is ignored by the runtime, and can only be set from a CONFIG.FPW or its equivalent for the runtime environment. The development version will take the TMPFILES setting from a CONFIG.FPW in preference to the registry entry.

You can confirm this easily - in your development copy of VFP, open the Tools-Options dialog, go to the Files Tab, and modify the setting for Temporary Files to be empty. Set this as default, and press OK. Exit VFP, and start another copy. Print the value of SYS(2023), and it'll be the starting directory for the executable.

Obviously, if this isn't where you want it, change it back...