I think this is the solution, though I may be off the right track...
Open a new query (SELECT) in design view.
Right click to bring up the query properties window.
Now turn the query into a pass-through.
The ODBC properties should now be available in the query properties.
Simply navigate to the DSN through the ODBC Admin form...
Hope that helps. Bit of a pain to get there since as soon as your turn it into a pass-through, the properties option disappears so you have to bring it up first! Well, maybe been solved on 2k+, Im stuck on 97 today!