My exe is in the same directory as the data on a server. I have a shortcut on my desktop that starts the exe. Unless I fill in the "start in" with the same directory my exe cannot find the data. To avoid this I open the data with the full path. To get the full path to the data I use...
StartDir=JUSTPATH(sys(16))+'\'
use (StartDir + 'mydbc!mytable') in 0 shared
Is there a way that is generally accepted as better than this?