>How can I setup a linked server to get access to a VFP table (DBF) that does not reside in the same folder as the containing VFP database (DBC)?
>
>We are able to create linked servers to VFP databases but until now the DBF's have been in the same folder as the DBC.
Did you try:
Select * from OpenQuery(VFPLINK, 'select * from (''c:\myFolder\Mytable.dbf'')')
Cetin