Hello, sounds like the lock rod may be detached from the door lock cylinder. This can be confirmed by removal of the door trim panel and internal inspection. Of course, nothing can replace a good physical inspection to confirm failure and come up with a plan to repair.
RepairPal Certified shops can diagnose and repair your 2007 Acura MDX. They provide transparent pricing with a minimum 12-month or 12,000-mile warranty on repairs and services.