I have an issue that I can't seem to resolve. I changed a data type on the SQL side from date to smalldatetime - in the hope that I could fix formatting issues on the Access side --- dates display as YYYY-MM-DD and they want to see MM-DD-YYYY.
Well nothing I did seemed to work. One recommendation was to open the table on the Access side in Design mode (despite the fact that no changes can be made on linked tables) and the date field shows it as a TEXT field. What the heck am I doing wrong.
I verified that all other tables with smalldatetime formatting show as Dates on the Access side.
Thanks a bunch in advance.