For some reason, access is storing the dates backwards when set to English-CA.
If I set my pc to English-CA, and I have my vb application write #11/1/2010#, access stores it as jan 1 2010. If I change regional settings back to English-US, and have the app write #11/1/2010# access stores it as Nov 1 2010.
In point of fact, Access always stores date/time values as a Double, where the integer represents the number of days since a given date and the decimal is the fractional time value. What you see is a formatting issue. In code, Access always expects the date in US format: