关于游标类型,这里有一段说明
The cursor type of the Recordset object affects whether the number of records can be determined. The RecordCount property will return -1 for a forward-only cursor; the actual count for a static or keyset cursor; and either -1 or the actual count for a dynamic cursor, depending on the data source.
同样受到影响的有 PageSize/PageCount,呵呵
所以我一般用 Select Count(*) From TableName Where ... 来返回一个 count