>>I am prepairing to distribute an application to our various offices. My supervisor would like the programs and screens etc. to run from the end users local drive while the data resides on the server. I originally created the project with the data in a "databases" directory under the program root. When I seperate these the DBC becomes invalid for all my tables. I put the path to the data in the set path statement and even tried to manulally open the server DBC using open database .... Nothing has worked so I am asking here.
>
>What we do is we make separate installation setup: 1 for DBC/TABLES and one for programs to make it flexible.
>
>VFP SETUP Wizard BTW is flexible enough to accomodate needs in distributing applications.


My previous reply was the cause - Pilot error!

The DBC file must be in the same reletive path as the data. You cannot move it with the programs. In the set path statement include the path to the DBC file and everything works fine.

Thanks for the help

Terry