Time coversions between SQL Server 2008 backend and Access 2013 front end

baytowel
baytowel used Ask the Experts™
on
I have an SQL Server 2008 table defined with 2 time(0) fields, but when I link to them through ODBC to MS Access 2013 front end, they come across as text fields. I need the server to hold an time(0) time with a medium time displayed in Access 2013. Where am I going wrong???
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
There is no direct equivalent in Access to data type Time.

Either change the data type of your field to DateTime (not DateTime2 which also will be read as text), or connect to your linked table via a simple select query that uses TimeValue or CDate to convert the text values to Date in Access; this, however, will be read-only.

/gustav
Distinguished Expert 2017
Commented:
In some cases, you can "see" newer SQL Server data types if you change your ODBC driver.  So instead of using the standard SQL Server driver, download the newest SQL Server Native Client driver which at this writing is 11.0

Author

Commented:
Trying both solutions...

Author

Commented:
Go ahead and close the question.  

Thank you.

Baytowel

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial