I have a number of databases in MS Access 97. Some tables in these databases are linked to ODBC tables in Oracle9/10. We would like to change the user name and password on the Oracle tables so each database in MS Access linking to the tables in Oracle will need to be relinked with the new credentials.

We would also like to automate this process of dropping the old links and making a new one through a module that can be run in every...