It's been a number of years since I've had the opportunity to use SQL Server, so am slowly getting my feet wet again. Client has a SQL Server table that contains 12M records and date field of type DateTime2.
I need to be able to link to this table from within Access, but Access sees the field as text.
Are there any issues with simply changing the datatype of the SQL Server field from DateTime2 to Date?
Can I do that in table design view, or should I run an Alter Table query? If the latter, what would be the appropriate syntax to change [docDate] from DateTime2 to Date