Have you looked at Thread #877950 ?

~~Bonnie

>Lets say I have the following VB.NET code to access a SQL Server table:
>
>

>      Dim lcConnString As String
>      Dim lcSQLQueryString As String
>      lcConnString = "user id=sa;password=password;Database=northwind;server=(local);"
>      lcSQLQueryString = "SELECT * FROM Suppliers"
>

>
>How would I modify it so I can have Suppliers to be a VFP table? Lets assume taht Suppliers.dbf is not part of a VFP DBC as it's a free table. So, lcConnString would have to be adjusted.