>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
If you do a MoveLast, you'll have the correct recordcount. Needless to say, this is not efficient.
You can do a SQL query using SELECT COUNT. The downside is that you ad another hit to you database (a fast one it is).