>>>>"\:\\FS_RENAL2\USER1\APPS\DB\MAIN\DATABASE\PATDB.DBC does not exist."
>>>
>>>Would this work:
>>>
>>>set default to \\FS_RENAL2\USER1\APPS\DB\MAIN
>>>use database\atable.dbf
>>>use database\another.dbf
>>>use database\thisone.dbf
>>>
>>>Note default does NOT start with \:
>>
>>Precisely. The problem would be the \: at the beginning.
>
>Hi everyone. I don't want to encode the server and path into the application (if I can at all help it) so that the app can be moved without much of a fuss.
>
>I have set up a shortcut on my desktop which has:
>Target: \\Fs_renal2\USER1\APPS\DB\MAIN\VMAIN.EXE
>Start in: \\Fs_renal2\USER1\APPS\DB\MAIN\
>
>The application start but once it trys to open the first table or database, I get the following error when the following line is executed
>
>open database database\patdb shared in 0
>
>Error message:
>
>File '\:\\FS_RENAL2\USER1\APPS\DB\MAIN\DATABASE\PATDB.DBC' does not exist.
>
>The path looks correct in the error message except for the \: part.
>
>Anyone got any ideas what may be causing the error?

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.