title: Sql Server date type appears as text field in MS Access
body: <p>I have a MS Access 2010 front end / SQL Server 2012 back end database, with a number of date fields in different tables. Sometimes I need to store the time, so I have used data types datetime or smalldatetime. However certain fields only need to store the date, so I used data type Date.</p>
  
  <p>My problem is that in MS Access, my ODBC-linked table shows the Date data type fields as Text. This is then leading to problems with some dates being stored in the yyyy-dd-mm format and others in the yyyy-mm-dd format.</p>
  
  <p>Is this a bug? Do I need to use smalldatetime?</p>
  
  <p>Thanks for any assistance,
  Jim</p>