有关asp与access的问题

[china_wu]

const adOpenKeyset=1
const adLockOptimistic=3

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db\bbsdb.mdb")
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from user",conn,adOpenKeyset,adLockOptimistic,adcmdtable
Response.Write(rs.RecordCount)

我用上面的code,为何记录数总显视为0呢？但表中有记录，请各位高手帮帮我

[ChinaOk]

try
先rs.movelast
然后再取recordcount的值

[zxlkxy]

‘adOpenKeyset,adLockOptimistic,adcmdtable ’可能这几个参数的问题，用3，1就没有问题，用3，2就不行，我也不知为什么！

[julyclyde]

,adcmdtable 去掉

[liuzxit]

用rs.open的rs.RecordCount這個屬性跟參數有關吧﹐你把rs.open改成rs.execute的方式看看行不。如下﹕
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db\bbsdb.mdb")
set rs=conn.execute("select * from user"
Response.Write(rs.RecordCount)

[liuzxit]

漏了一個 )
set rs=conn.execute("select * from user")