Access 2002 ODBC - Date Issue

Need help after linking a Navision Attain table in Access 2002. Using criteria in a date field sometime yields no results, but other times it returns records. It does it for both one specific date, and also date ranges. It seems to be a ODBC driver problem. Anyone been able to resolve this problem. I have tried adjusting the options in the ODBC setup with no luck. Very frustrating, HELP…

Did you solve the problem yourselfes ?