That would be because SQL Server and Access do not have the same starting dates. Why do you have dates in your database like that?
I figured out what happened. The dates actually do match. I'm converting an ADP over to accdb, and under ADP I had to bump the date back 2 days, because Access was producing a date of 1-1-1900 while SQLs was 12-30-1899. Now that they match under accdb, my code was bumping it back 2 days.