Ramifications of Re-Naming queries?

[KrispyData]

I inhererited a database with queries, forms, etc aggregated on the Primary
Account info. My project is to modify the database for Individual Acct info.
I made a copy of the PrimaryAcct. mdb. Individual Acct info is available on
the same tables that PrimaryAcct .mdb is based on. I am making changes in
several queries (there are also many queries based on queries). Mostly, I am
just adding Individual Acct#'s and updating formulas. Since I am naming this
database IndividualAcct.mdb I would like to rename some of the queries that I
updated just to make it more meaningful. For examle, instead of
PrimaryCollections I want to change it to lndividualCollections.

Will this nane change affect the functionality of any access object that is
dependend on this query? For example, if Query A is based on Primary
Collections and I re-name it to Individual Collections, will Query A go
berserk and not know what I am askign for?

 

[John Spencer]

Yes. Any query that used the renamed query or any form or any report
that uses the renamed query will fail.

I use Find And Replace add in to rename objects in the database. AND I
always make a backup copy before I do this and then thoroughly test
afterward.

Here are some other products that also work with various versions of Access.

Products to document the database and do a global find and replace. All
have Access 97 and later versions. Some don't have an Access 2003
version, but may still work with Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Commercial
Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace


Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/ (Free)
V-Tools: http://www.skrol29.com/us/vtools.php (Free)

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================