I am linking tables into an access database and I am having issues with being able to read the data which is coming over the link in a readable date format. The data is being displayed as an interger (ex. 1069432250) and I need to be able to sort on this field as well as report on it. In this format, no one will be able to read the data.
I am linking this access database to the SQL Server Database through a ODBC connection.
How is this field defined in SQL Server? What does it show as a field definition when looking at the linked table in design view within Access? where in the world do you live/work? That is, what is the date format that you are using? Those answers will be a big help in helping you.
Those two answers will help a lot.