Rox,

>I've recently done an exe where the dbc and dbfs were all included in the distributed exe and had no problem running a SELECT against anything within that same exe (didnt have your scenario where your crossing two different app's but hey it worked in a single exe)

Yep. works in the SAME app or exe, but not if you open the files in a different app/exe.

>So here's a WAG...
>>select * from testtable
>
>slap in a DBF() maybe?
>select * from DBF(testtable)

I think you meant:

* add quote marks since testtable is the actual name, not a variable.
select * from dbf("testtable")

This does avoid the error message...by activating the open dialog. Not much help really. Thanks for the WAG, but...

BTW, the function DBF() shows the path to the original file, even though it has been moved/deleted.

Any other WAG's that might prove fruitful?