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?