Dim conn As New ADODB.Connection
Dim rs As New ADODB.ConnectionPrivate Sub Command1_Click()
rs("入库日期") = Label9.CaptionEnd SubPrivate Sub Command2_Click()
男女鞋入库.Show
Me.Hide
End SubPrivate Sub Form_Load()
Dim sql As String
sql = "select * from [ctt]"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "/db1.mdb"
rs.Open sql, conn, adLockOptimistic
Label9.Caption = DateEnd Sub
Dim rs As New ADODB.ConnectionPrivate Sub Command1_Click()
rs("入库日期") = Label9.CaptionEnd SubPrivate Sub Command2_Click()
男女鞋入库.Show
Me.Hide
End SubPrivate Sub Form_Load()
Dim sql As String
sql = "select * from [ctt]"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "/db1.mdb"
rs.Open sql, conn, adLockOptimistic
Label9.Caption = DateEnd Sub
rs("入库日期") = Label9.Caption
rs.Update
End Sub
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
set rs=conn.execute(sql)这句:
rs.Open sql, conn, adLockOptimistic
参数也不对,adLockOptimistic是锁定方式,在它前面还有一个游标类型参数...