Auditing Utility for MS Access 2003

[djyip13]

I am trying to find a utility that will inventory the objects (tables,
queries, forms, etc) within a MS Access database. For the tables, I'd
like to know if they are internal or linked, and for the queries I'd
like to know what type of query it is. Is there such a utility? Any
help would be greatly appreciated.

 

[Tom Wickerath]

For a free add-in tool, try CSD Tools
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

It works with Access 2007 as well, but it has not been fully regression
tested with this version, thus the author's note: "Important - This add-in is
not compatible yet with Access 2007." I have used it successfully with Access
2007 running on Vista.

An excellent, but not free, tool is Total Access Analyzer:
http://www.fmsinc.com/products/analyzer/index.html

It will do what you want, plus a whole lot more.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Arvin Meyer [MVP]]

I am trying to find a utility that will inventory the objects (tables,
queries, forms, etc) within a MS Access database. For the tables, I'd
like to know if they are internal or linked, and for the queries I'd
like to know what type of query it is. Is there such a utility? Any
help would be greatly appreciated.

This free utility will build a table of all the tables and fields within
your database:

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

This query will create a list of all the objects in the database:

SELECT DISTINCTROW MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type) In
(1,5,-32764,-32766,-32768,-32761)));