Code that finds all referecence objects

[Guest]

How would i go about writting code that can print a list of all the
tables/queries used within a database. The purpose is to be able to location
tables that are no longer needed (those that were used for 1 off requests).
I already have code that can list all the objects (tables, queries,
reports...) so this is the next step.

I know the built in analyzer is able to retrive the recordsource for reports
and teh sql for queries so maybe i should start there. is the code for this
available?

thanks for any and all help!
ben

 

[Marshall Barton]

How would i go about writting code that can print a list of all the
tables/queries used within a database. The purpose is to be able to location
tables that are no longer needed (those that were used for 1 off requests).
I already have code that can list all the objects (tables, queries,
reports...) so this is the next step.

I know the built in analyzer is able to retrive the recordsource for reports
and teh sql for queries so maybe i should start there. is the code for this
available?

There are a few third party tools that can do that kind of
referenceing analysis. Trying to write your own is an
extremely advanced programming project that is probably not
worth the effort if you can buy a time tested tool.

FMS Inc has an extensive package called Total Access
Analyzer, among several others, that includes that kind of
capabilty. See http://www.fmsinc.com/ for details

There are a couple of others out there on the web that are
less expensive and can locate all uses of a particular name.
Take a look at SpeedFerret at http://www.moshannon.com/ to
see if it meets you needs. Also check Find and Replace at
http://www.rickworld.com/products.html