Where is this field used?

[LynnQCC]

I'm working with Access 2003 and have two fields in a table that hold *very*
similar content. I'd like to find out where in the dbase each of these fields
is used, so I can assess the impact of deleting one or the other. Is there
some tool I can use to do that?

Thanks,
Lynn

 

[Dorian]

No there is no built-in tool to show that
You will have to examine every query and every form and report data source.
You can scan the VB code by the entire project so that is the easy part.
If you have macros, you will have to examine each one.
Often, its quicker to just delete the column then retest everything and see
what 'breaks'.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[John W. Vinson]

I'm working with Access 2003 and have two fields in a table that hold *very*
similar content. I'd like to find out where in the dbase each of these fields
is used, so I can assess the impact of deleting one or the other. Is there
some tool I can use to do that?

Thanks,
Lynn

There isn't, directly; you can use Tools... Analyze... Documenter to document
all your queries, forms and reports, write them out to a Word document or text
file, and do a text search of that file.

Or, you can purchase or obtain one of the several third-party documentation
tools:

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


I'm not certain that all lf these are still available, my references have been
around for a few years.

 

[John Spencer]

NOTES on the LINKS
BAD LINK: Free: http://www3.bc.sympatico.ca/starthere/findandreplace

Find and Replace: http://www.rickworld.com
Good link and has versions to support up to Access 2007 (Beta version only for
2007) - Shareware (Approx $40-$60 depending on version)

Speed Ferret: http://www.moshannon.com
Good Link and supports up to Access 2003 (2003 support requires an earlier
version of Access (2000 or 2002 to also be installed - $200 range)

Total Access Analyzer: http://www.fmsinc.com
Good Link: Supports up to 2007 ($300 range)
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[John W. Vinson]

NOTES on the LINKS
BAD LINK: Free: http://www3.bc.sympatico.ca/starthere/findandreplace

Find and Replace: http://www.rickworld.com
Good link and has versions to support up to Access 2007 (Beta version only for
2007) - Shareware (Approx $40-$60 depending on version)

Speed Ferret: http://www.moshannon.com
Good Link and supports up to Access 2003 (2003 support requires an earlier
version of Access (2000 or 2002 to also be installed - $200 range)

Total Access Analyzer: http://www.fmsinc.com
Good Link: Supports up to 2007 ($300 range)
John Spencer

Thank you, John - I'll update my file!

I'm glad to see that FMS has updated TAA. I'll go out and upgrade, since I am
starting to use 2007 (kicking and screaming...)

 

[Lynn Trapp]

John,
What are you kicking and screaming about? ;-)

--
Lynn Trapp
MCP, MOS, MCAS


:

 

[John W. Vinson]

John,
What are you kicking and screaming about? ;-)

it's uncomfortable being all tied up in Ribbons.

 

[Lynn Trapp]

Ah, yeah, but gifts come with ribbons too. ;-)

 

[John W. Vinson]

Ah, yeah, but gifts come with ribbons too. ;-)

And Gift is the German word for poison!