I am using Access 2003. I am trying to set up a test environment by copying the access database to a test subdirectory. I have an ODBC connection to a DB2 database called DB2Prod which is the production database. I created another ODBC connection called DB2Test which points to the test database. There are several queries that reference DB2Prod. I would to do a search and replace on all the queries and change all instances of DB2Prod to DB2Test. Is there a way of doing this without opening up all 100 queries?