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