what happens if you run the following code in the db you are working with?
If the dates come out correctly, then I would look at what Access is trying to send, something has to be ill formed. if the above does NOT work, then you have a problem with your install. I will assume you are current on service packs.
if object_id('tempdb..psytmp') is not null drop table #psytmp
create table #psytmp(f1 datetime)
insert into #psytmp values('31-Dec-9194')
insert into #psytmp values('31-Dec-9999')
insert into #psytmp values('01-Jan-1753')
select * From #psytmp
drop table #psytmp
I would run the profiler and see exactly what is coming from Access. Did you have a problem with my last suggestion from your other post?
(Knowledge is power! Get some!)