Data Element Where-Used

[Guest]

We are in the process of consolidating many Access databases into a more
"centralized" database. I am looking for help in being able to identify all
the data elements associated with each tables in all these databases. Any
help would be appreciated.

 

[Arvin Meyer]

The best tool I've found for that job is Speed Ferret.

http://www.moshannon.com/

But that assumes you have an idea what you are looking for. If not, you may
want to look at the native database analyzer (Tools ... Analyze ...
Documentor) Or you may try a commercial product like Total Access Detective:

http://www.fmsinc.com/Products/detective/index.html

If it's just tables you need to document, I have a free utility on my
website:

http://www.datastrat.com/Download/FieldDescription2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[George Nicholson]

Arvin:

FWIW, FMS Access Detective is more for comparing 2 databases & spotting the
differences. FMS Access Analyzer is their Documentor plus.