Changing Table Names - what's the impact?

[xavier.batlle]

hi there - we have a customer that we run 95 queries for as part of their processing. These queries are based on a number of tables that are named in a specific way. They want to change their main table name, but from what I can see, the table names that the queries are based on, don't always seem to change. Therefore we will need to go through every query potentially to see if it works. Is this right? Thoughts very welcome!

I have done it several times and to avoid problems I follow these steps:
- 1) Rename the old table with the new name
- 2) Create a query using the the old table name with all the fields of the new table
- 3) Change old table name with the new table name in all querys (Optional in some cases)

This is not an exaustive list of all the tasks but pehaps you find useful.

 

[ebs17]

Correct. It is important to explicitly point out that automated services running in parallel require resources of their own and take them away from the main application.

Regarding the original question: There are several Find&Replace tools that cleanly perform renaming at any point in the frontend (queries, forms, reports, macros, VBA codes).