麻烦老师们帮忙看看,我设计了一个VB6的界面,通过它向access数据库录入信息。但现在运行到AddNew时,系统提醒说对象关闭时,不允许操作。但我的VOC.accdb是已经成功打开的,因为我看文件夹中已经多了一个VOC.1accdb。找了半天都没找到原因,请老师指点。
Private Sub Command4_Click()
Dim conn As ADODB.Connection
Dim rst As ADODB.RecordsetSet conn = New ADODB.Connection
With conn
.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " & App.Path & "\VOC.accdb;"
.Open
End WithSet rst = New ADODB.Recordset
With rst
.ActiveConnection = conn
End With
With rst
.AddNew (到这里系统就报错了)
rst.Fields(1) = VBA.Environ("username")
rst.Fields(2) = Date & ", " & Time
rst.Fields(3) = Combo1.Text
rst.Fields(4) = Text1.Text
rst.Fields(9) = Text2.Text
rst.Fields(11) = Text3.Text
rst.Fields(13) = Text4.TextDim z As Integer
For z = 0 To 2
If Option1(z) <> 0 Then rst.Fields(5) = Option1(z).Caption
If Option6(z) <> 0 Then rst.Fields(8) = Option6(z).CaptionNextFor z = 0 To 3
If Option2(z) <> 0 Then rst.Fields(6) = Option2(z).Caption
If Option3(z) <> 0 Then rst.Fields(7) = Option3(z).Caption
If Option7(z) <> 0 Then rst.Fields(12) = Option7(z).Caption
NextFor z = 0 To 1
If Option4(z) <> 0 Then rst.Fields(10) = Option4(z).Caption
Next
.Update
End With
rst.Close
conn.Close
Set rst = Nothing
Set conn = NothingEnd Sub
|