>>>>>Could anyone please point me to the link to download VFP Oledb provider?
>>>>
>>>>You can get it with VFP7 only. There's no separate download available.
>>>
>>>Thanks.
>>>
>>>Now, I installed VFP 7.0 but having problems accessing free tables? I think I can't find the proper syntax for the connection string to access free tables. Here is what I tried and didn't work.
>>>
>>>oConn = CREATEOBJECT("ADODB.Connection")
>>>oConn.ConnectionString = "provider=vfpoledb.1;data source=c:\temp\"
>>>oConn.Open()
>>>
>>>oConn.Open() returns NULL. What am I doing wrong?
>>
>>It always returns Null. You'll get an error if it cannot open connection.
>>
>>BTW, don't forget to install SP1 for VFP7.
>
>I have installed SP1...There is no error when I open the connection but when I open te Recordset using this connection, RS.RecordCount returns -1....
>

Make your recordset client side.

oRs.CursorLocation = 3 
oRs.Open(...)