Hi All,
I actually encounter a problem when storing COleDatetime in an Access97 database, when the COleDateTime day is <= 12, the day and month are swapped when I look at the record newly inserted in the database, but when the day is >= 13, all is ok. I searched to find a solution, it seems that the regional settings available in the control panel or via the SetLocaleInfo win32 sdk can solde the solution, provided that you set the short date format to MM/dd/yyyy, but I NEED to keep this parameter to dd/MM/yyyy because of displayed dates ...
So also tried modifying the Locale Identifier keyword available in the Connection String setting it to 1036 (France) instead of 1033 (USA), but then problem is still there.

If possible, I would like not to modify the locale setting everytile I insert or update dates, setting locale back to the previous value, it seems heavy and not very nice.

Does someone knows a solution