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....
Bob Tracy
Never engage in a battle of wits if you're only half armed.