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