We have just tried to reproduce your issue but ucanaccess works correctly. Notice that the query above can select records between the 20.00 and the 21.00. Please post a proof database(just one table with 3-4 recors) with the query that, in your opinion, doesn't work.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm Sorry, it was a mistake. I found the problem in a minute after to write.
Last edit: Jaume 2016-02-15
We have just tried to reproduce your issue but ucanaccess works correctly. Notice that the query above can select records between the 20.00 and the 21.00. Please post a proof database(just one table with 3-4 recors) with the query that, in your opinion, doesn't work.
The Ucanaccess works perfectly, I was wrong and the problem was in another place.
Sorry for the inconvenience ...
No issue ;-)