The procedures (functions) in themodule have worked for years.
what has changed recently? Windows or Access version? Office version?
If every module won't compile (as stated, fix or comment out one, the failure just trickles down to the next one) then it is something generic, like references or bitness, but that seems to have been covered. Then maybe all functions use early binding and the wrong Office versions related to those references.
surely you can post at least 1 function (please enclose in code tags - thread menu bar #) so we can zero in?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.