>It has VFP 9 installed, i created an ADO Connection on the server to VFP and works fine.
>
>SQL Server 2000

Does account, that SQL Server runs under, has access to the directory with VFP tables? Can you see the list of tables when you expand the Linked Server in the Enterprise Manager? Can yoou post the Linked Server script?