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

The above example uses the en-gb locale identifier (2057)