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