Well, did you tried to open these ODBC files with Access ?
By the way, I think your DSN doesn't point to the file you try to open later with Access. Most probably you write successfully in another .mdb file.

If you I would test with the alternative syntax, specifying the file path directly in the connection string. This way you could make sure you open later the right file.
(BTW, you can't open a DSN with Access. DSN are only definitions: they specify a file and a driver to manage it, exactly the same informations you have in the full syntax)

Laurent