Linked SQL date field showing as text field in MS Access 2010
When I link to my SQL server 2008 R2 table in MS Access 2007 and 2010 the date type field in SQL is showing as a text field in Access. I have read that MS Access 2010 supports the SQL date field, so I upgraded but I am still seeing the same issue. When i create a MS Access database link to the SQL table it shows as text. Any ideas how this can be fixed without changing the SQL data type to datetime?