Are you using VFP OLE DB provider or VFP ODBC driver for linked server? It works for me with both. Can you post the properties of your linked server?
>Hi,
>I have a test on adding VFP DBC to SQL server as linked server. I able to add it successully. However, once I call sp_tables_ex to view the database's tables list, only free tables were listed. The other tables are not. Any ideas?
>
>Again, I used to have this problem before when I try to use 3rd party product to access my DB using ODBC. It work fine if I use VB dataenvironment to access the VFP db.
>
>Pls advice.
>
>Thank you
--sb--