I've had smears, and boy were they awful for me. I'm late 60s now and not much natural lubrication left down there, none in fact, which is normal enough for my age, but I can feel the pain already!
It's 'normal' but not right or something you need endure.
Have you considered using vaginal estrogen? You should if you're 'dry' even if you aren't sexually active because it's to keep your vagina and bladder healthier.
If you start now, and your scan is in over 2 weeks, it should be working by then and help. You can buy it over the counter or on prescription from your GP- it's Ovesse cream or Gina (tiny tablets.)
I think a pp has given a pretty accurate account of why a scan is not the same as a smear.
They don't use a speculum and you aren't 'opened up' - it's wand that is about the size of a fat finger. They put a condom on it first and plenty of lube.
Sometimes they may need to press on your tummy slightly to get a better picture of your ovaries etc.
And you have it done with an empty bladder. So no issues of holding on!
@101trees Why did it take 40 minutes?! I have scans now and then for monitoring (done by an expert consultant) and it's 10 minutes max.