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 ?