sqlextendedfetch - movelast

Desperately trying to find a way to move fast to the last record in a recordset.
I use the odbc sqlextendedfetch function with the option SQL_FETCH_LAST. For some reason this seems to be a very slow way to get to the last record in a recordset.
When executing this statement, every record is being fetched until the end of recordset is reached. "Select count(*)..." is no solution to the problem.
Can anybody help me with this problem.

P.S. I don't want to use the MFC classes.

Many thks in advance.

Perhaps SQLFetchScroll will work faster. Have you examined the index(s) on the table?

Good Luck.

Can't find info on SQLFetchScroll function...
(Using VC++ 5)