Stephen,
Once the database is open and current you don't need any pathing to USE the tables.
>As a test I created another program in another folder to open and browse one of the tables in the data directory using the SET PATH statement and it works fine. Arghh! It's just ignoring it in my application.
Then it sounds like you've got some other code that is altering your environment somewhere along the line.