>I have a fairly complicated view that works properly when running the program within the VFP environment.
>When compiled to an EXE and all files copied to another drive, the view returns zero results.
>Other views in the EXE work properly, and manually executing views from on the new drive returns proper results.
>I've validated, packed and recompiled the database and project. Any suggestions of what/where to look to find the cause?
Sounds like one or more of the tables or index files are compiled with your EXE. Make sure that none of these files are in the Other files in the project, or that they are excluded if they are in the project.