At 40, women can still have success rates.
Success depends on three factors: 1. Skill of the surgeon, 2. Length of tubal segments remaining, and 3. Age of the patient. In skilled hands, the surgery is safe and the risk of an ectopic is less than 5%. Ivf is also an option but generally costs a lot more. Hope this helps. Good luck.