If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Where used" Analysis to find all occurrences of fields, tables, e
I just inherited a poorly designed database and have been assigned the task
of cleaning it up, properly normalizing tables with 30 fields (!) in them - yes, welcome to my nightmare. Here's what I need: a way to find where all fields, tables, forms, queries, macros, reports, modules, visual basic procedures ... are mentioned. if Access can create it, I need to know what its source is (macro, table.field, report, ..), where it's called from, and what other modules call it. In other words, I need a complete analysis of all relationships NOT defined as database relationships (linked tables - that's easy). The relationships I'm looking for are coding relationships because I can't delete or change a field unless I know where it's being used and what side effects will be generated by these changes. Anybody have or know of a free utility or report generator that will do that? A nice visual/graphical documenter would be outstanding. Thanks, Deb |
#2
|
|||
|
|||
On Tue, 31 May 2005 16:03:34 -0700, "CoachDeb"
wrote: Here's what I need: a way to find where all fields, tables, forms, queries, macros, reports, modules, visual basic procedures ... are mentioned. if Access can create it, I need to know what its source is (macro, table.field, report, ..), where it's called from, and what other modules call it. In other words, I need a complete analysis of all relationships NOT defined as database relationships (linked tables - that's easy). The relationships I'm looking for are coding relationships because I can't delete or change a field unless I know where it's being used and what side effects will be generated by these changes. Anybody have or know of a free utility or report generator that will do that? A nice visual/graphical documenter would be outstanding. Free: http://www3.bc.sympatico.ca/starthere/findandreplace Find and Replace: http://www.rickworld.com Speed Ferret: http://www.moshannon.com Total Access Analyzer: http://www.fmsinc.com The last three are not free, but check the websites, I believe that Rickworld and Speed Ferret have demo versions (variously handicapped). John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to find the gap? | Günter Brandstätter | General Discussion | 6 | September 3rd, 2004 12:02 PM |
Outlook XP Quick Find Public Folders | Bret | Contacts | 0 | August 13th, 2004 05:09 PM |
FIND (Two questions) | gary | General Discussion | 3 | July 8th, 2004 03:07 PM |