Are you using the latest version of the VFP OLE DB provider?
Did you notice any pattern in which tables are not visible?

>We are try to access VFP 6 data from SQL Server using the VFP OLEDB Provider
>After creating the provider, we scroll the list of available tables (all free tables) several tables from the same folder (about a dozen out of one hundred) don't appear in the list.
>
>Does any one have any ideas why some would appear and others would not?