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:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210069

http://www.mvps.org/access/datetime/date0005.htm

I use variation of the second link in applications that will be used outside the US.