Doru,

The 'data source' is a DBC name in the format 'X:\dbcdir\mydata.dbc' or a directory for the free tables in the format 'X:\fretabledir\'.
The open method always returns .null.
To browse ADO recordset download file#9783.

Take a look at http://msdn.microsoft.com/library/default.asp?URL=/library/techart/ADOJump.htm.

>I did have the path in the connectionString...
>
>>Try to specify full name for DBC or full path for a free table.
>>
>>>I'm trying to access VFP data from VFP using OLEDB. Here is my code in the command window:
>>>

OConn = Createobject("ADODB.Connection")
>>>oRS = Createobject("ADODB.Recordset")
>>>OConn.ConnectionString = "provider=vfpoledb.1;data source=myData"

>>>myData is a .DBC or a free table
>>>

?OConn.Open()

>>>This always returns .NULL.
>>>

?oRS.Open("Select * from myTable",OConn)

>>>This returns:
>>>1. NULL if the myData is a DBC and myTable is a table in the myData
>>>2. OLE exception error c00000005 if myData and myTable are a free table
>>>
>>>I hope it's the syntax, but I'm afraid it's just nonsense and I need to RTM first?