>>You cam also create a linked server with VFP ODBC driver. It's faster than another one, allows read/write access to data but doesn't support any new data features introduced after VFP6.
>
>How is that in MSDE?
>
>I use this commands to create linked server:
>
>

sp_addlinkedserver @server = 'MyLinkedServer',
>@srvproduct = 'VFP',
>@provider = 'VFPOLEDB.1',
>@datasrc = 'c:\MyTables'
>

>
>I don't find any documentation about using ODBC for linked server. What should I change or where should I look?
>

See Re: SQL linked server with oledb Message #633186.
BTW, back to the speed of a query against a linked server. See OPENQUERY() and Distributed Query Architecture in BOL.