>BACKGROUND:
>I modified a program - added few lines of codes. Prior to this, the program runs perfectly; no problems in locating the tables used in the program.
>
>HERE'S THE CHALLENGE:
>The program compiled successfully, but when it's executed it is looking for the tables used in the program itself. (These tables are included in the main database which are validated.) Funny thing is, once pointed to the location of the tables (a prompt pops up asking a user the whereabouts of the tables), the program continues without a hitch. Any suggestions / help?
>
>Thanks in advance,
>Nelson
Nelson,
It's likely your addition somewhat closes tables, changes path etc. "...once pointed to the location of the tables.." is the answer itself. You should provide the correct path before it asks to you. Simply add a "set path ..".
lcCurPath = set("path")
lcDataPath = "Your path to tables"
set path to (lcCurPath+";"+lcDataPath)
Cetin