If the lights are out, sometimes it can be due to the wiring at the lift gate harness being pinched and possibly damaged. Check at the little rubber boot that carries the wiring at the hinge area and see if the wires inside are still intact. That would be the most common cause, but certainly not the only one. Worth a look.
RepairPal Certified shops can diagnose and repair your 2003 Acura MDX. They provide transparent pricing with a minimum 12-month or 12,000-mile warranty on repairs and services.