>>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.

Yeah, I do this as well. He (Evan) was having difficulty defining a UNC path to his DBC and tables which are on a network drive while the APP is installed on local drive.