[dba-SQLServer] Displaying SQL Server Time(7) in Access

I know!  My memory is getting really bad.

I knew that was the problem but when I made the change (in SQL Server) it didn't help.  It turns out 
that my framework was determining that the control's data source was a date and putting in a date 
format string.  Once I stopped that it all started working.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 6/5/2012 11:15 PM, Stuart McLachlan wrote:
> I seem to recall having the same discussion about a year ago where we identified the
> problem with the new SQL Server Date and Time types and ODBC returning them as strings
> :-)
>