Specifying locale identifier using Microsoft Access ODBC Driver
Connection string
This Microsoft Access ODBC Driver connection string can be used for connections to Access 97, Access 2000, Access 2002 and Access 2003.
Use this one to specify the locale identifier which can help with non-US formated dates.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;
Locale Identifier=2057;Uid=Admin;Pwd=;
The above example uses the en-gb locale identifier (2057)