title: MS-Access front-end does not recognise dates from SQL Server
body: <p>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.</p>
  
  <p>SQL Server-s format is <code>YYYY-MM-DD</code><br>
  Access' format is <code>DD-MM-YYYY</code></p>
  
  <p>When the date is displayed in a text-box, it is displayed as a string (without the little calendar icon next to it).<br>
  Is there anyway I can configure my Access front-end so that it recognises SQL Server's dates?</p>
  
  <p>Cheers.</p>