A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Where used" Analysis to find all occurrences of fields, tables, e



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2005, 12:03 AM
CoachDeb
external usenet poster
 
Posts: n/a
Default "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  
Old June 1st, 2005, 04:26 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.