Since you have hard-coded the path in your SQLStringConnect [SourceDB=c:\Apps], then 'myfile' has to exist in the source computer's c:\Apps folder. To see what tables you can SELECT from, get a cursor of tables with the following:
lnRetVal = SQLTABLES(nHandle, 'Table', 'crsTables')
>Mark,
>
>AError() tells me that file 'myfile' does not exist. But the other servers do have that directory and table.
>
>Also, if I run this from my PC and query the table on my PC, it works. But if I go to another PC and query my PC, I get the file does not exist error.
>
>What does it look for on the other PC to make this work?
Mark McCasland
Midlothian, TX USA