VB.NET ACCESS数据库SQL查询使用时间的问题

在SQL SERVER数据库中使用update tb_test set FirstName='Jason' where datime >='2012-04-26'

但是ACCESS数据库不能使用单引号“ ‘ ”，Update Device_info set 是否过期='已过期' where 检定有效期 <= #" & Date.Now().ToShortDateString & "#，需要使用“ # ”，总结一下，备忘。

ACCESS数据のbetween and 查询

"select * from maintb where 时间 between #" & DateTimePicker1.Value & "# AND #" & DateTimePicker2.Value & "# order by ID " & ComboBox2.Text & ";"

"select * from maintb where 姓名='" & ComboBox1.Text & "'and 时间 between #" & DateTimePicker1.Value & "# AND #" & DateTimePicker2.Value & "# order by ID " & ComboBox2.Text & ";"