It could be that since you're going into menopause, you aren't getting well lubricated or as lubricated as you used to. So the sex is causing irritation and small tears in your vaginal walls. You might want to try some store bought lubricant and see if it helps.