>> My understanding is that linked servers are remote SQL Server servers, not other data sources.
>
>You can use the Linked Server feature of SQL Server to connect to any hetrogenous (sp?) data source including ODBC sources like Access and VFP (Although Access does have an OLEDB provider).
>
>-Mike

Yea Mike that's what I am trying to do... except it doesn't seem to work. I assume I have to create a linked server to do a Heterogeneous query (like Miek Polson mentioned).

Any ides why VFP ODBC data would not show up in the table. I am nt sure what to use on the Security tab... but I have tried impersonate and specific account with still no results.

BOb