>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....

PMFJI. We've been bitten by this a number of times. Cursors client side don't always behave properly. I'm not clear as to what are the differences between the two and when you would want to do one vs. the other.