In women without imperforate hymens, or who don't have a condtion like vaginisums, the vaginal canal and opening can never be 'too tight" when a woman is relaxed, aroused and properly lubricated.
No sort of sex permanently stretches the vaginal canal or opening.
If you have menstrual flow, you don't have an imperforate hymen. If when you masturbate, you can insert a finger or two into your vaginal canal, you likely don't have vaginismus either (and your gynecologist can also confirm that -- if you're sexually active and not seeing one each year, get smart and start doing so). You can use a hand mirror to see if you might have a partial hymen which is blocking or bifurcating a portion of your vaginal opening, as that's also a possibility.
But if none of those things are so, chances are when you've attempted penetration, you were not relaxed and/or already aroused enough from other sexual activities or have not been using extra lubricant when you need it.
Copyright 1998, 2014 Heather Corinna/Scarleteen
Scarleteen.com: Providing comprehensive sex education online to teens and young adults worldwide since 1998
Information on this site is provided for educational purposes. It is not meant to and cannot substitute for advice or care provided by an in-person medical professional. The information contained herein is not meant to be used to diagnose or treat a health problem or disease, or for prescribing any medication. You should always consult your own healthcare provider if you have a health problem or medical condition.