The order in the SET PATH setting is very, veeery important!! Make sure that all the paths really exists, and that the CD drive is NOT in the path! And finally, make sure that all the paths are relative, and not absolute.

>Hi all,
>
>I just installed an application which starts in a C:\VFP folder and has a Global Variable set to the app's DBC path. I was shocked to see that Forms with Data Environments were opening VERY slowly.
>
>Searching through various UT threads and working with the client, we eliminated the usual suspects - Memory Issues, Spyware, Anti-Virus Scanning, Network problems, etc. Test moving the Data to a Local Drive did NOT fix the problem. Interestingly, some computers ran the forms normally while others suffered from a latency period before startup directly related to the number of Tables included in the Data Environment.
>
>Just to make things more interesting, one computer which had previously run at normal speed now was running slow! Finally, I suspected that the issue had to do with the hard coded Database Property of the Cursors which was developed on a machine with a D drive. Low and behold, D on the client's computers is mapped to a CD drive which when empty results in a slow Form Load and when loaded with a CD results in a normal Load time. Computers with no D letter mapped, open the forms at normal speed.
>
>Since I've had various other systems up for years and never heard of this problem I wonder if all my other clients have a D drive mapped to a non-removable device or always have a CD in their D Drive.
>
>I am considering making Form modifications suggested in previous threads which use code similar to Doug Hennig's SetDataDirectory.
>
>
>Some Questions though:
>
>1. When I view the SCX's directly, the Database Property of the folders displays '..\DATA\(DBC Name)' - the relative path when the form was created/edited. However in the Database Designer the Full Path (including the D Drive) for the DBC is displayed. Why the discrepancy?
>
>2. What is causing the delay when the D drive is mapped to a removable device which is empty...clearly the Search is slowing down when the system is looking for this device..I'm just surprised it takes so long to acknowledge that nothing is there before going on to check the SET PATH value which points to the Application DBC.
>
>3. Can I safely Edit the Database Property for Cursors directly in the SCX and remove the File Path info or use a global Variable or Function?
>
>
>P.S. This might answer some of the other Threads which could not account for forms opening slowly on client's systems.