Set cn = New ADODB.Connection
CnStr = " Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\info97.mdb;Persist Security Info=False"
cn.Open CnStr
Set rs = New ADODB.Recordset
If rs.State = adStateOpen Then rs.Close
rs.AddNew
rs.Fields("姓名") = Text1(0).Text
rs.Update MsgBox ("添加完成!")
CnStr = " Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\info97.mdb;Persist Security Info=False"
cn.Open CnStr
Set rs = New ADODB.Recordset
If rs.State = adStateOpen Then rs.Close
rs.AddNew
rs.Fields("姓名") = Text1(0).Text
rs.Update MsgBox ("添加完成!")
Set rs = New ADODB.Recordset
If rs.State = adStateOpen Then rs.Close
rs.AddNew在if語句時﹐你已經將記錄集關閉了﹐當然不允許操作了
CnStr = " Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\info97.mdb;Persist Security Info=False"
cn.Open CnStr
Set rs = New ADODB.Recordset
If rs.State = adStateOpen Then rs.Close
rs.open ...... <------------- rs.AddNew
rs.Fields("姓名") = Text1(0).Text
rs.Update MsgBox ("添加完成!")
记得Rs.open后面还有参数呢。你自己看看Msdn上哦!
CnStr = " Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\info97.mdb;Persist Security Info=False"
cn.Open CnStr
Set rs = New ADODB.Recordset
SQL = "insert into info(卫字) values ('" & Text1(0).Text & "')" rs.Open SQL, cn MsgBox ("添加完成!")