Between dates.... a strange behave

Hi there, I've a nice sql, like this:

SELECT * FROM registro where status like '0' and pretendida between #01/06/2003# and #30/06/2003# order by pretendida desc

pretendida means expected, it`s a date format field in the mdb,  the problem is that I get many rows from the mdb and some outsite the range of the dates.

I tried LCID codes but it's all on its right way to dd/mm/yyyy.

so now what?

Thank you very much faubo, but it didn't work in my asp.
Finally I found a good answer at www.4guysfromrolla.com

I had to change my dates without LCID, I had to made a Function that change the month xx/06/xxxx to xx-jun-xxxx, in that way it works with mdb files because they store dates in its particular way of counting day y time since 30-dec-1899.