vb 6.0 关于rs.movelast的问题为什么只能到第九条记录？

Question

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open "provider=microsoft.ace.oledb.12.0;data source=" & App.Path & "\" & "DB_zhaolu.accdb;persist security info=false"
rs.Open " select * from 招录信息男", cn, adOpenKeyset, adLockOptimistic

Dim nan%
rs.MoveLast
nan = rs.Fields("序号")

我在招录信息表中存放超过9个记录他也只能读取到第九个记录，这是为什么？

Answer 1

rs.Open " select * from 招录信息男 order by id", cn, adOpenKeyset, adLockOptimistic