Sean Connery really irritates me

Although he is a good actor Sean Connery's accent in this film just is not right. In the movie he says he moved to the US when he was 10 years old.
Children are very susceptible to accent change if they move to a different place, and I know people who have moved to america and then 10 years later their accent has completely changed.

How could Sean Connery have been cast in this film with that accent? He still sounded extremely scottish!!!!!
His daughter (Meg Ryan's character) even said within her life they have moved around the US.

One final thing, is that surely Connery's daughter would have a slight accent like him.
My mum has a very strong accent and even though i was brought up away from where she was, because I heard her voice everyday I still picked up a little of her accent.

Also when Connery played Indiana Jones' father, he had a scottish accent which seemed really stupid.

Does anyone have any views on this?

xxx---------------------------------xxx