>>The problem is that VFP hardcodes the path to all the data. Even if I do "SET
>>DATABASE TO c:\tripsoft\data\test\tripsoft.dbc", it wants the database to be
>>in my development dir.
>>
>>I thought I could fix that by going into the .SCX and taking out the path. >Now it won't use the database even if I physically change the directory to the
>>subdir. That's no good.
>
>When you took out the path, did you leave in the dbc name, and then SET PATH TO your data? I've done that before, successfully....

I left the dbc name, but didn't set path. Does SET PATH TO change the default dir? The thing I'm trying to avoid is changing the default dir because when I create temp tables from SQL, I want them to be created on the local hard drive.

Thanks,

-Michelle