>>Could someone please tell me how I return the number of records in my ADO recordset?? The recordcount property only returns -1. I am presuming I need to choose another library or use an SQL statement to determine the number of records...If anyone has a solution I would be extremely grateful. Thanks, Paul
>
>This is actually related to the CursorType property of the recordset. If memory serves, only CursorTypes of adOpenKeyset and adOpenStatic support the RecordCount property. CursorTypes adOpenForwardOnly (the default) and adOpenDynamic do not. While adOpenForwardOnly is the most efficient CursorType, if you have to have the RecordCount it makes more sense to change the CursorType property than running a separate query to determine the number of records returned.
>
>HTH
Memory seems to serve quite well. The previous post is I believe a solution.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams
