>>Can someone help me on this ....?
>>
>>I have two directories that reside on 2 different drives
>>e.g. g:\app\dbf (developement drive) and t:\app\dbf (live drive)
>>
>>In the developement environment, whenever I create a new form and add tables to the form's data environment. I select tables from g:\app\dbf (this is where my dbc reside as well). My default directory is g:\app. But, when i compiled my app to an executable file and run this under the live environment the form still pointing to the develomemt drive(g:\app\dbf) for data even though I have my start up directory point to t:\app.
>>
>>In my application, I specificly open up the dbc using 'open database ..\dbf\app.dbc' at the beginning of the program. This doesnt seem to work as expected.
>>
>>
>>Any help is appreciated ....
>>
>>Thanks
>
>Hi,
>
>If the database is in a child sub-directory from the application open the database with dbf\app.dbc rather than ..dbf\app.dbc.
>
>hth,

Thanks for the tip ...

I tried Jonh and George's way, but it doesn't work... I think the dbc's path has been saved along with the form, so it get compliled into the exe as well... Actually, I am running you guy's suggestion under the test emvironment(not the exe file) but the form still poiting to the live data. I will try Donald's method, it sound's alright ... though i still think there must be an easier way than that ...

To.