Is it possible to change the database name thru code for a linked odbc table?

When I originally linked the tables I was prompted to select a database name and input my userID and password. I am trying to run a select query from a few tables. I need to get the data from several differenct databases (same tabels) so I would like to be able to do this thru code instead of linking the same tables for each databases.