You may add a line to your main program
SET PATH TO Tables and just use OPEN DATABASE Accounts instead of trying to use the path.
>Dear Expers
>
>1- On D:\ there is a folder called "Pay"
>2- It has sub folder named "Tables"
>3- Folder Tables has account.DBC and DBF's
>4- Pay.exe is located on D:\
>5- The Shortcut of pay.exe is on D:\
>
>Propeties of "Shortcut to pay.exe"
>
>Target=C:\pay.exe
>Start in=C:\Pay
>
>My startup or main prg has following codes to set path
>
>lcSys16 = sys(16)
>lcProgram = substr(lcSys16, at(":", lcSys16) - 1)
>set default to left(lcProgram, rat("\", lcProgram))
>
>
>When I doluble click "Shortcut to pay.exe" then show program error as
>
>File 'd:\tables\account.dbc' does not exist.
>
>I use following method to open dbc
>
>CLOSE ALL
>CLOSE DATABASES
>OPEN DATABASE(sys(5)+alltrim(sys(2003)))+'\TABLES\ACCOUNT' EXCLUSIVE
>USE login IN 0
>USE comm IN 0
>
>
>I want to ask
>Why Exe does not access to dbc
>
>Shoul I modify this line
>OPEN DATABASE(sys(5)+alltrim(sys(2003)))+'\TABLES\ACCOUNT' EXCLUSIVE
>
>
>Please help
If it's not broken, fix it until it is.
My Blog