Set mcnn = New ADODB.Connection
mcnn.Open "provider=Microsoft.jet.oledb.4.0;persist security info=false;data source=" & App.Path & "\wx.mdb"
Set rs = New ADODB.Recordset
sql = "select * from main where " & Form1.Adodc1.Recordset.Fields(9).Value = " 奔腾3主机 "
rs.Open sql, mcnn, , , adCmdText
a = rs.RecordCount
vbnprn3.PrOutText 3300, 7800, " ", 22, 0, 1, 0, 0, 0, CStr(a)
rs.Close
Set rs = Nothingmcnn.Close
Set mcnn = Nothing这句运行后出现错误:参数类型不正确,或不在可以接受的范围内,或与其他参数冲突."请问这句SQL应该怎样写
mcnn.Open "provider=Microsoft.jet.oledb.4.0;persist security info=false;data source=" & App.Path & "\wx.mdb"
Set rs = New ADODB.Recordset
sql = "select * from main where " & Form1.Adodc1.Recordset.Fields(9).Value = " 奔腾3主机 "
rs.Open sql, mcnn, , , adCmdText
a = rs.RecordCount
vbnprn3.PrOutText 3300, 7800, " ", 22, 0, 1, 0, 0, 0, CStr(a)
rs.Close
Set rs = Nothingmcnn.Close
Set mcnn = Nothing这句运行后出现错误:参数类型不正确,或不在可以接受的范围内,或与其他参数冲突."请问这句SQL应该怎样写
"='奔腾3主机'"