P.S.: You are getting the data, execute your code and something like this:

oRS.Fields('any field name').Value or oRS.Fields(n).Value where n is a number representing a field position in your table (it's zero based).

>Paul,
> You're set to a server-side cursor, change to client-side (adUseClient). HTH
>
>Bob
>
>>I'm trying to get Ado working with some Fox databases and keep getting 0 records. The State for both the connection & recordset objects is 1 after the open. I'm using a System DSN pointing to the DBC.
>>
>>Here's the code:
>>oConn = CreateObject("ADODB.Connection")
>>oConn.Open("galsinc")
>>oRS = CreateObject("ADODB.RecordSet")
>>oRs.ActiveConnection = oConn
>>oRs.Source = "SELECT * FROM Customers"
>>oRs.Open
>>?oRs.ReccordCount
>>
>>The last line always returns -1.
>>
>>Grrrr....