Good question. None of us seems to have come across the answer in the month since somebody else was unable to connect to Access 2007 from Perl.

Like you, they got it to work using a DSN in the Data Sources console, but we never heard that they managed to connect to a filename given at runtime.

Perhaps this belongs in a Frequently Unanswered Questions section.