Hi Jon,

Thanks for info. To clarify, the four part notation works for VFP tables in DBC but doesn't work for free tables. Or I'm missing something?

>Sergey,
>
>Just as an FYI, OPENQUERY() is actually not the only way to get at an ODBC linked server. I was able to figure out a way to connect to an ODBC VFP linked server using the 4-part notation by using the linked server name for the first and second parts (e.g. VFPData.VFPData..Trades). Works like a charm.
>
>The driving force for having figured this out was the need to use a declared script variable inside my SELECT statement. And yes, using OLE DB is just too slow.
>
>Laterness,
>Jon