>>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.
Well, if you want to go distributed you have no choice but to go with disconnected client side recordsets. That or concoct a solution of your own.