Renaming ALL Queries/Macros/Forms in less steps..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’m consolidating 5 working dbs into 1 main db and I’d like rename all
queries/forms/macros to match each databases functional names. For example:

1.AP Database
All objects will have *AP-(plus current object name)
i.e. qAP-XXXXXX for queries
fAP-XXXXXX for forms
mAP-XXXXXX for macros
etc…

2.Color Database
All objects will have *CLR-(plus current object name)
i.e. qCLR-XXXXXX for queries
fCLR-XXXXXX for forms
mCLR-XXXXXX for macros
etc….

I have a minimal knowledge of VB, with that said, is this task possible
using queries?

Will appreciate any help I can get.

Thanks in advance

Rob
 
I would invest in some software to do this. Otherwise, you are liable to find a
LOT of broken references. I've used one of the programs below to aid in a
complete redesign and renaming of existing databases. It was a major timesaver
(days of effort condensed into a few hours).

For instance, if you change a query name, you have to find every place you used
that query (all forms, macros, queries, modules and reports) and change the name
in those locations also. Not an easy task to do.

There is a free addin named Ezy Documenter Wizard at
http://www.aadconsulting.cjb.net/ezydoc.html which might help
There is a version for A97 and one for A2K/XP

Renaming software:
Find and Replace http://www.rickworld.com (Trial Ware)
Speed Ferret http://www.moshannon.com (commercial)
Total Access Analyzer http://www.fmsinc.com (Commercial)

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
 
John: Is that the correct address for Ezy Documenter Wizard? I'm getting a
Bad Gateway error when I try to go to it.
 
Seems to be bad for me also. I guess I'll have to update my FAQ database.

I googled and found that I can find the PREMIUM edition at

http://www.aadconsulting.com/ezdocprm.html

for 29.95 (US $).

That said I didn't find the STANDARD EDITION available at any of the sites I
visited in my cursory check.

I guess I will remove it from my FAQ for now. Thanks for the followup.
 
FYI,

The standard edition of Ezy Documenter (and the other Free Add-ins) are
available at:

http://www.aadconsulting.com/addins.html


but only under this condition:

"If you buy a Premium Tool or Add-In or the Access Utilities CD
or if you subscribe for a one-off subscription fee of US$9.95.

Buy a product or become a subscriber and you will be emailed
instructions on how to access these files: "



I've used Ezy Documenter (the free version) for a couple of years and
wouldn't be without it. I'll probably buy the premium version soon to be
able to customize the printouts.
 
Back
Top