ADODB to Access with DNS, get .mdb file path

[Irocase]

I wanna get the filename and file path of an access .mdb file.

I connect to the access file per DNS, it works super, but when i wanna call a macro function (such as table refresh from extern db), i have to connect to the file as Access.application, and then i need the filename.

Or how can i get the ODBC informations with the DNS name ?

Have you any idea?