MS-Access front-end does not recognise dates from SQL Server

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.

5
задан Speed 13 September 2010 в 15:54
поделиться