Access 查询时显示记录被删除...

[sswwyy]

select count(1) as total from E_Msg where username='dln' and Date>=#2013-11-02 00:00:00# and Date<=#2013-12-02 23:59:59#

Access查询是显示记录被删除， 时间去掉select count(1) as total from E_Msg where Sender='dln'能正常查询

但换成其他用户却又能正常执行
如select count(1) as total from E_Msg where username='ft' and Date>=#2013-11-02 00:00:00# and Date<=#2013-12-02 23:59:59#

[Im_Sorry]

引用 楼主 sswwyy 的回复:

select count(1) as total from E_Msg where username='dln' and Date>=#2013-11-02 00:00:00# and Date<=#2013-12-02 23:59:59# Access查询是显示记录被删除， 时间去掉select count(1) as total from E_Msg where Sender='dln'能正常查询 但换成其他用户却又能正常执行 如select count(1) as total from E_Msg where username='ft' and Date>=#2013-11-02 00:00:00# and Date<=#2013-12-02 23:59:59#

百度下，access支持哪些关键字和函数！

[sswwyy]

顶

[sswwyy]

,没人知道吗？

[myhope88]

是不是该用户的记录确实不存在呀