title: TIME datatype in SQL Server 2008 will not accept time from Access form
body: <p>I am using an Access form on the front end, bound to a SQL Server 2008 table. I have an <code>Arrival Time</code> column of datatype <code>Time</code>.  </p>
  
  <p>But I get an ODBC error every time I try to save a record. Error states:  </p>
  
  <blockquote>
    <p><em>Invalid character value for cast specification.</em></p>
  </blockquote>
  
  <p>Time displays as <code>10:00:00 AM</code>. I have tried with and without a time format in the properties of the field, and with/without an input mask of various types. Does anyone know how to avoid this error?</p>