I have a SQL Server 2008 database with an Access front-end. My problem is that Access does not recognise SQL Server's dates as they are in a different format.

SQL Server-s format is `YYYY-MM-DD`  

Access' format is `DD-MM-YYYY`

When the date is displayed in a text-box, it is displayed as a string (without the little calendar icon next to it).  

Is there anyway I can configure my Access front-end so that it recognises SQL Server's dates?

Cheers.