Hello all - I used the upsizing wizard within Access 2k3 to create a new SQL db on my SQL 2k SP4 server. Everthing went smoothly, except the access Date/Time field converstion to datetime. When I open the tables containing the date & time fields from Enterprise Manager, they show with the correct separation of dates in one column, and times in another. But when I run the command below from QA, it comes back with two columns, each containing both dates and times.
"select * from <tablename>"
According to the developers (I'm the dba) this is causing issues with their application. I've found the articles below somewhat referencing the issue, but either cannot get to the full articles, or cannot get the formatting correct to resolve the problem.
Any help would be appreciated!
August 17, 2006 4:37 PM
August 21, 2006 12:03 PM