sql = "insert into domainname(Department,Name,loginname,password,Purview) values('" & TxtDepartment & "','" & TxtName & "','" & TxtLoginName & "','" & TxtPassword & "','" & TxtPurview & "')"
'    conn.Execute (sql)   这种方法通不过,下面那种方法也通不过
    conn.CursorLocation = adUseClient
    rs.Open sql, conn, adOpenKeyset, adLockOptimistic
请高手指点...