I used the SQL Server Migration Assistant to convert a table to a SQL table. I selected the link table option so I can still use my Access database. However, when i did it seems that the date/time field was converted to a text field in Access. When i view the table properties it shows that field as text and if I try to run a query based on date it doesn't work.
It looks like the SQL Server has it right but the access linked table does not. Is there any way to fix this?