Software To Analyze MS Access Databases

[djyip13]

I have been looking online for different software tools that will
analyze MS Access databases. The one I've come across with the most
positive reviews is FMS's Total Access Analyzer. Is there any other
third-party tools that are similar?

Thanks in advance.

 

[Arvin Meyer [MVP]]

That's one of the better ones. If you are just looking for tools to document
the database, you can find some free ones on my site:

For tables:
http://www.datastrat.com/Download/FieldDescription2K.zip

For other objects:
http://www.datastrat.com/Code/DocDatabase.txt

and for references:
http://www.datastrat.com/Code/GetReferences.txt

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

 

[djyip13]

That's one of the better ones. If you are just looking for tools to document
the database, you can find some free ones on my site:

For tables:http://www.datastrat.com/Download/FieldDescription2K.zip

For other objects:http://www.datastrat.com/Code/DocDatabase.txt

and for references:http://www.datastrat.com/Code/GetReferences.txt

--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

Thank you, Arvin.
You mention that Total Access Analyzer is one of the better ones.
What are others? All I've seen online has been that one or freeware /
shareware that do pieces.

 

[Duane Hookom]

Depending on what you are expecting out of a tool, you might want to check
out the resources/links at Jeff Conrad's page
http://www.accessmvp.com/JConrad/accessjunkie/doctable.html.

 

[Larry Linson]

I'm not sure "analyze" is an appropriate term, but I use the free "mztools"
which is very handy when developing DBs. Rick Fisher's "Find & Replace" is
useful... http://www.rickworld.com. Speed Ferret...
http://www.moshannon.com is also good, but last time I looked they had not
updated for Access 2003 or 2007, but that was quite a while back.

Larry Linson
Microsoft Office Access MVP

 

[Arvin Meyer [MVP]]

Thank you, Arvin.
You mention that Total Access Analyzer is one of the better ones.
What are others? All I've seen online has been that one or freeware /
shareware that do pieces.

There's one built right into Access in the Tools menu. Most of them do
comparison analysis like:

http://www.dataassistance.com

Rich Fisher's Find & Replace and Bob Snyder's Speed Ferret can analyze
dependencies, like finding a field name anywhere in the database.

http://www.rickworld.com/products.html
http://www.speedferret.com/

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

 

[djyip13]

What I'm trying to do is initially identify any objects, particularly
queries, within a finite set of MS Access databases that perform some
kind of insert, append, update or delete of data in linked SQL
tables. Unfortunately that finite set is, at a minimum, 1400 distinct
MDBs, with the possibility of peaking at 4000. So I'm trying to avoid
having to go into each MDB, and check each and every object to see
what that object is linked to and to see what kind of action it is
performing. That's why I'm looking at tools to do this.

Hope this clarifies what the daunting task I have ahead of me!

 

[Arvin Meyer [MVP]]

I know of no tools that will loop through a series of databases. You could
write something and while it may take some time, in the end it might be less
time consuming than opening each one.