Here is a seemly simple problem that is stumping me:

I have a select statement that uses Access' DISTINCTROW clause for performance reasons.
The problem is that ASP-db does a SELECT COUNT(*) FROM X WHERE Y to determine
the rowcount to control the buttons. Unfortunately, the COUNT(*) is different then when
you do SELECT DISTINCTROW A,B,C FROM X WHERE Y. Is there anyway I can tell
ASP-db to use the recordset's RecordCount instead of the default COUNT(*)? Or can
you think of any otherway I can get ASP-db to work properly?

Yes, I can write the SQL statement another way to avoid the DISTINCTROW, but I
was getting unexceptable performance. I will have to switch to SQL Server if this
doesn't work.

Any help would be appeciated,

-Doug