These are the Access instructions for this issue:
"Change the default country/region
Changing the default country/region changes the standard settings for numbers, currencies, time, and date to those most commonly used for that country/region.
On the Microsoft Windows Start menu, point to Settings, and then click Control Panel.
Double-click the Regional Options or Regional Settings icon.
In the Your locale (location) list, select the country/region you want to use as the default.
If you are using Microsoft Windows 2000 and don't see the item you want, first select the check box next to the appropriate language in the Language settings for the system box.
Click OK, and then restart your program.
Note When you change the country/region in the Your locale (location) list, settings, such as the format for displaying currency and date, may also change. Check all the tabs in the Regional Options dialog box to make sure they are correct."
If this doesn't work, you can do the SQL work around and have three columns for the date:
DD = DatePart("d", Date)
MM = DatePart("m", Date)
YY = DatePart("yyyy", Date)
Or sort out the dates in an array by breaking them down and then reassembling them for your code - which is a pain, or breaking them down and reassembling them for display only.