>If you are using a UNC, why do you include database\ in the Open Database command? That is a relative path statement that would be the cause of the problem.

>  #Define gcDataPath "\\Fs_renal2\USER1\APPS\DB\MAIN"
>  open data gcDataPath + "PatDB" shared in 0

>or something similar. You could even store the UNC in a "user table" or "app configuration table" so you can change that if needed.

Just to avoid some hardcoding,
#Define gcWhereAmI addbs(justpath(sys(16,1))
will return the actual path of the .exe file (or will it? I've had cases when it returned the development path... in fpd2.0 or so).

In case we don't have control of the paths and other things at install time, it's just another line:

set defa to (gcWhereAmI)

This way the app doesn't give a damn for its location - it knows where it is, uses it as the default path and all the relative paths follow from there.