How do I determine row count using MS Access.

[martindavey]

I have a CRecordset object.

CString strSQL="select * from [myTable]";
OldRS.Open(CRecordset::dynaset,strSQL,CRecordset::readOnly);

I now want to store the number of rows in an integer.

Any ideas?

 

[DavesTips]

In principal you can use GetRecordCount(), but only after reading through the records to the end (not with MoveLast()). The most efficient way of counting records via SQL is generally Select Count(*) From ... Hope that this helped! ;-)