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 is this field used?
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 |
#2
|
|||
|
|||
Where is this field used?
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". "LynnQCC" wrote: 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 |
#3
|
|||
|
|||
Where is this field used?
On Wed, 27 Jan 2010 12:20:01 -0800, LynnQCC
wrote: 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 W. Vinson [MVP] |
#4
|
|||
|
|||
Where is this field used?
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 wrote: On Wed, 27 Jan 2010 12:20:01 -0800, LynnQCC wrote: 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. |
#5
|
|||
|
|||
Where is this field used?
On Thu, 28 Jan 2010 10:15:29 -0500, John Spencer wrote:
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...) -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Where is this field used?
John,
What are you kicking and screaming about? ;-) -- Lynn Trapp MCP, MOS, MCAS "John W. Vinson" wrote: 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...) -- |
#7
|
|||
|
|||
Where is this field used?
On Thu, 28 Jan 2010 13:36:02 -0800, Lynn Trapp
wrote: John, What are you kicking and screaming about? ;-) it's uncomfortable being all tied up in Ribbons. -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Where is this field used?
Ah, yeah, but gifts come with ribbons too. ;-)
-- Lynn Trapp MCP, MOS, MCAS "John W. Vinson" wrote: it's uncomfortable being all tied up in Ribbons. -- |
#9
|
|||
|
|||
Where is this field used?
On Mon, 1 Feb 2010 05:37:02 -0800, Lynn Trapp
wrote: Ah, yeah, but gifts come with ribbons too. ;-) And Gift is the German word for poison! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|