Access 2007 Data Dictionary Reporting Tool

[Daniel Jacobs]

Access 2007
Can somebody recommend a decent reporting utility so that I can report on
the structure of my database? I would like to be able to select the elements
(e.g. indexes) and properties (e.g. description, required etc.) that I want
to see on the report rather than settle for the verbose output provided by
the Access database documenter tool. The tool must offer reports on tables,
fields and relationships.

 

[Tom Wickerath]

Access MVP Alumni Jeff Conrad has a free tool available, CSD Tools, which may
suit your needs. Although it has not been fully regression tested in Access
2007, he indicates that it seems to work okay in this version:

CSD Tools
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

There is also the venerable Total Access Analyzer software. I use and
heartily recommend this software to any serious Access developers. While it
is not free, it is a very good product that will likely save you tons of time
in the future:

Total Access Analyzer
http://www.fmsinc.com/products/analyzer/index.html


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

 

[Daniel Jacobs]

Thank you Tom. I cannot stretch to the cost of the Total Access Analyzer
software and i cannot get the CSD Tools to install in my Vista/Access 2007
environment (it tells me that I have no tables to report on). Thank you for
trying.

 

[Tom Wickerath]

Hi Daniel,

I just tried installing Jeff's CSD Tools add-in on my Toshiba laptop, which
has the Vista Ultimate operating system with Access 2007. I clicked on the
Office Button (round button in upper left corner), followed by the Access
Options command button, and then I selected Add-Ins. On the Manage dropdown,
I selected "Access Add-ins", and then clicked on the "Go..." button. This
brough up the Add-in Manager dialog box. I clicked on the "Add New..." button
and navigated to the "CSDTools2000.mda" file. When I did this, I received an
error that I did not have administrative privileges. However, I did not
receive an error that indicated "no tables to report on".

I had to search for the file msaccess.exe and, once found, right-click on it
and then select Run As Administrator. Then I repeated the above steps. This
time the CSD Tools add-in installed without any problem. I tested it out
using the Northwind 2007 database, and it seems to work fine.


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

 

[Daniel Jacobs]

The "no tables to report on message" was generated after I tried to run a
report despite the install problems. I have just repeated the steps as
advised (as administrator) and all is now working well. Thank you Tom.

 

[Tom Wickerath]

Hi Daniel,

You're very welcome. I'm glad to read that you had success!


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