Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
However -- you may want to look into the CDao* (e.g. CDaoRecordset) classes. They usually have all the functionality that the ODBC classes have, plus more. If you are working with an Access database, they are definately the way to go. The CDaoRecordset has a working count function, so you can just select <column>, move to the last record, and get the record count, thus removing the need for your first query.