cb2001: Your husband is attempting to deal with his opiate addiction. Has he had some measure of success in this respect? If so, then why not give him some space to achieve his own recovery? You can't recover for him. You can help him by recognizing that this is his recovery. He can recover only if he wants to do this badly enough. He should not have to lie to you. There's no point to it if you know he's lying. Just don't ask him. He probably knows that you know so why ask? If you think he's getting better, making some progress, then give him a pat on the back.
As for his using alcohol. Yes, that may be a bad idea. Encourage him to discuss this issue with other recovering opiate dependent persons, and with counselors and physicians if necessary. But again, it's his choice. You say you are tired of being a detective, but you aren't a detective. You're his wife and friend. Alanon may be of some help to you. Good luck
W.