Controlling ODBC

Is there a way to use a form in MS Access to tell the computer which DSN to

use when opening a .mdb?  Our accounting software creates a new database
for 
each year.  Therefore I have a DSN for each year like DSN2006, DSN2007,
etc.  
I use MS Access to create re****ts and manipulate some of the data in the 
databases.  I generally have to create a separate .mdb for each year. 
This 
is not efficient since if I make a change to 2006.mdb I then have to open
and 
manually change 2007.mdb.  I could use Tools >> Database Utilities >>
Linked 
Table Mgr.  However if my employees use the .mdb I do not want to share
the 
database admin password with them.

I would like to use a form in MS Access with radial buttons ( or drop down

list) to control which DSN is used for queries and re****ts.