ASP如何判断ADO INSERT操作是否成功？

[jury]

<%set mconn=Server.CreateObject("ADODB.CONNECTION")
mconn.Open "cz168","guest",""
fp_sql="INSERT INTO member (netname) VALUES ("allen")
Application.Lock
set rs=mconn.Execute(fp_sql)
Application.unLock%>
请教两个问题：
1.如何判断“mconn.Execute(fp_sql)”动作完全成功？
2.“Application.Lock”和“Application.unLock”是否恰当？

[jury]

???

[wjl2000]

(1)
On Error Resume Next
mconn.Execute fp_sql
if Err then
Msgbox "出错！"
end if

(2)
不需要“Application.Lock”和“Application.unLock”,应用程序会自动处理

[jury]

谢谢您！