<div>
You should use find and replace functionality. You can find many free programs for this in google.<br />
<br />
Ayway, best practices when connection name stored in configuration file and then you can easely change ODBC connection name.
</div>


You should use find and replace functionality. You can find many free programs for this in google.

Ayway, best practices when connection name stored in configuration file and then you can easely change ODBC connection name.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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?<br />
<br />
Thanks,<br />
<br />
Mark
</div>
</div>


Hi,

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?

Thanks,

Mark

Search 100 Queries For Table Name

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.