求教：关于ADO连接Access后按时间段查询的问题

代码如下：
Dim SqlStr As String
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim cmd As New ADODB.Command
DS = DataStart.Text
DE = DataEnd.Text
SqlStr = "Select*From DATA Where T3p1_P_logFileDbTime Between #" + DS + "# and #" + DE + "#"
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DATA.mdb"
Set cmd.ActiveConnection = Conn
cmd.CommandText = SqlStr
Rs.CursorLocation = adUseClient
Rs.Open cmd, , adOpenDynamic, adLockBatchOptimistic
Set Exc1.DataSource = Rs
End Sub
Private Sub Form_Load()
DataStart.Text = Format(Now, "yyyy/mm/dd hh:mm:ss")
DataEnd.Text = Format(Now, "yyyy/mm/dd hh:mm:ss")
End Sub

混用PM

编译成exe再运行试试，F5运行执行sql有时候有问题。

问题已经解决，是Access数据库时间那个字段格式被设置成了文本，所以才导致了这个情况