请帮忙看下代码关于查询的,菜鸟请教

来源:百度知道 编辑:UC知道 时间:2024/06/06 19:12:22
set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
GetTimeK = "2008-03-07"
GetTimeJ = "2008-03-20"
GetName = "陈涛"
cn.ConnectionString = "rovider=Microsoft.Jet.OLEDB.4.0ersist Security Info=False;" _
& "Data Source=" & App.Path & "\Bank.mdbersist Security Info=False" '连接ACCESS数据库
cn.Open
If cn Is Nothing Then
MsgBox "连接失败,请查看路径!"
End If
strSQL1 = "select * from inquery where inname='" & GetName & "' and intime >=#" & GetTimeK & "# and intime<=#" & GetTimeJ & "#"
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
rs.Open strSQL1, cn
intCount = rs.RecordCount '这里的intcount是我自己定义的用来记录个数的,可是程序跑起来之后strSQL1不报错,根据GetTimeK,GetTimeJ ,GetName这三个限制条件在数据库里查询,却发现intCount始终是零,没有查询结果,这是为什么那?
cn.Conne

cn.ConnectionString = "rovider=Microsoft.Jet.OLEDB.4.0ersist Security Info=False;" _
& "Data Source=" & App.Path & "\Bank.mdbersist Security Info=False" '连接ACCESS数据库
代码有错: rovider ==> Provider
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0ersist Security Info=False;" _
& "Data Source=" & App.Path & "\Bank.mdbersist Security Info=False" '连接ACCESS数据库