Ramifications of Re-Naming queries?



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

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

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

Free (For Access XP Only??):

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question