In what way isn't it respecting Regional Settings?
If you're talking dates, then yes, you must use mm/dd/yyyy in queries
(although an unambiguous format serves as well). See Allen Browne's
"International Dates in Access" at
http://allenbrowne.com/ser-36.html or
what I had in my September 2003 Access Answers column for Pinnacle
Publication's "Smart Access" newsletter. (The column and accompanying
database can be downloaded for free at
http://www.accessmvp.com/djsteele/SmartAccess.html)
