I linked my tables and datatype changed from date to text ???

[Stanislavnba]

Hello, I have an SQL server on one remote PC and my back end is there on an SQL server.
My front end is access. I only have 3 PC with versions of the FE.
Today the internet stopped and the IP of the server changed(nothing major so far) .
So I just re-linked the tables on the other two FE (the 1st FE is on the server machine).



The problem is that for some reason when I relinked the tables, the DATE does not come up as date and it comes as shorttext. Which screwes half the queries on the FE.
Any idea how I can fix this ?

[isladogs]

What was the datatype for the date fields in SQL Server?

[Stanislavnba]

The datatype in SQl Server is (datetime2(0), null) it shows off as this 2019-12-14 00:00:00

[isladogs]

That's what I thought.
Datetime2 provides greater precision but isn't supported by Access.
Unless you really need the extra precision, I suggest you change it to datetime in SS or use CAST as datetime.
Alternatively in Access try using CDate(nameoftextfield)

[Stanislavnba]

I've fixed it , it was because of the ODBC driver , I used SQL Server , and it needs to be SQL Native Client 11.

[isladogs]

Excellent. I didn't realise that would work.