My agency recently upgraded to SQL Server 2008 R2 and I immediately began taking advantage of the Date datatype. However, my front-end application, MS Access 2003 does not seem to recognize the date datatype. Access treats the date datatype as 'text'. Any thoughts on what to do? Do I have to find all the 'date' fields and convert back to datetime? Thanks.