请问这段代码哪里有误？

[xon]

<%
DbPath = SERVER.MapPath("dwcenter.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=server.createobject("adodb.recordset")
sqltext="select Name,right(Birthday,4),Telephone,Oicq,Email,Company,Address,Zip from xy_center order by name"
rs.open sqltext,conn,adOpenkeyset,adlockoptimistic,adcmdtext
a01 = rs(0)
a02 = rs(1)
a03 = rs(2)
a04 = rs(3)
a05 = rs(4)
a06 = rs(5)
a07 = rs(6)
a08 = rs(7)
%>

请问这段代码哪里有误？
其中rs.open sqltext,conn,adOpenkeyset,adlockoptimistic,adcmdtext是什么意思？

谢谢！！！

[hchxxzx]

rs.open sqltext,conn,adOpenkeyset,adlockoptimistic,adcmdtext
太烦锁了
只打开，不更新
rs.open sqltext,conn,1,1
进行写操作
rs.open sqltext,conn,1,3

全部OK

[popcode]

sqltext="select Name,Birthday,Telephone,Oicq,Email,Company,Address,Zip from xy_center order by name"
rs.open sqltext,conn,3,3
a01 = rs(0)
a02 = right(rs(1),4)

[star20]

同意楼上的！