Private Sub Command4_Click()
Dim Cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/水泥搅拌站工程/msdb/copdb.mdb;Mode=ReadWrite;Persist Security Info=False;"
sql = "Select * from ms_equipment"
rs.Open sql, Cnn, adOpenKeyset, adLockPessimistic
Label6.Caption = rs("stone")
End Subrs.Open sql, Cnn, adOpenKeyset, adLockPessimistic提示错误我没有使用DSN
Dim Cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/水泥搅拌站工程/msdb/copdb.mdb;Mode=ReadWrite;Persist Security Info=False;"
sql = "Select * from ms_equipment"
rs.Open sql, Cnn, adOpenKeyset, adLockPessimistic
Label6.Caption = rs("stone")
End Subrs.Open sql, Cnn, adOpenKeyset, adLockPessimistic提示错误我没有使用DSN
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货