Hi Mike,
Not sure, but I believe that windows, 2000 and above, disconnect any drive/paths not actively being used after an amount time (not sure what the time is). And I think that might be causing your problem.

>This only happens on some machines:
>When the user starts the program, they get an error: "Database cannot be found" (basically a file not found error.) If they cancel and retry running the application, it works fine.
>
>This worked fine on a Novell server with drives etc. The system has been changed from Novell to Windows 2003 server.
>
>This is a snippet of the code that sets the paths and default directories on the server when the application starts up.
>

>Local lcSys16, lcProgram,lcDefaDir
>lcSys16 = SYS(16)
>lcProgram = SUBSTR(lcSys16, AT(":", lcSys16) - 1)
>Cd LEFT(lcProgram, RAT("\", lcProgram))
>If RIGHT(lcProgram, 3) = "FXP"
>   Cd ..
>Endif
>lcDefaDir=curdir()
>set default to (lcDefaDir)
>Set PATH TO  BCDE, DATA, FORMS, GRAPHICS, LIBS, MENUS, PICTS, PROGS, QUERS, REPORTS, SCRNS, SYSTEM
>

>The database resides in a directory of the root called SYSTEM.
>The line that gives the error as mentioned above is:
>

>open data secu shared
>

>This never fails on the Novell server, but fails on the Windows 2003 server.
>This is what is in the properties of the shortcut on the user's desktop.
>The full path to the 2003 server application is:
>

\\FileServer\NewShopLink\ShopLink.exe

>Any ideas about how to get around this?
>
>TIA,
>Mike