Question Best way to change the name of an object used in many queries?

[mgibson]

Hi,

I have a query that I would like to change the name of. The query is the backbone of my database and is used by many other queries, forms, and reports. If I change the name using "Rename" then the name changes in the navigation pane but not in all the query/form/reports designs, thus rendering them unusable.

What is the best way to change the name of a query that's used in many other queries, forms, reports without having to redesign everything with the new name?

Thank you for your help, it is very much appreicated.

 

[Mile-O]

Question is, why would you want to change it? Surely the query name isn't visible in any way to the user.

 

[jdraw]

I agree with Mile-0, why?

However, you can copy a query and save it with a new name.

The query is the backbone of my database and is used by many other queries, forms, and reports.

I think this is very rare, and would suggest you may want to do some reading/research on database design.

 

[sxschech]

Here are two programs that can do a find and replace. I use the first one. The second one is free and haven't tried it yet, but has been recommended by others on this forum. As for changing a query name, I don't see why that should be a problem and often find there are cases where a name that made sense at one point doesn't now or needing to point to a different object and renaming is the easiest way to solve it.

Find And Replace, it is around $40, but it does a lot of things, can find and replace information and names in queries, tables, reports, macros, modules, forms. They offer a free trial. http://www.rickworld.com/

--------------------------------------------------------

V-Tools is freeware and does the renaming and many other functions too.

http://www.skrol29.com/us/vtools.php

 

[mgibson]

I would like to change the name of this query for the reason sxschech points out. It was originally designed for one purpose but has evolved to the point where it's name is no longer relevant and becomes confusing when other designers are adding functionality to the database.

Is there anyway to do this without installing 3rd party software?

Not sure copying the query and saving it with a new name would help as all the other queries would still reference the original name/query.

It was a little misleading to say this query is the "backbone" of my database, rather I meant to say it is used to group and manipulate information from multiple tables. This new "group" of information happens to be very useful and is used in many other queries and forms.

Is there a way to do a find and replace within access? I thought about viewing each DB object in SQL view and doing a find and replace but access doesn't allow me.

Any other ideas?

I appreciate the help