Try to use ADO its a great one.....


>Hi
> How to connect VFP Database using VB? I tried the following code, but it cannot connect to
>
>Private Sub Command1_Click()
>Dim WRK As Workspace
>Dim db As Database
>Dim rs As Recordset
>
>Set WRK = CreateWorkspace("", "admin", "", dbUseJet)
>
>Set db = WRK.OpenDatabase("TAX", dbDriverNoPrompt, False, _
>"ODBC; DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted=Yes;Null=Yes;Collate=Machine;
>BackgroundFetch=Yes;Exclusive=No;SourceType=DBC;SourceDB=C:\WINDOWS\Desktop\SmallProj\tax.dbc")
>
>End Sub
>
>Any idea?
>
>Thank you