What's where

  • Thread starter Thread starter garysibio
  • Start date Start date
G

garysibio

Hi,

My wife uses a program called ParishSoft which is written in Access
2003. The authors put the data in a multitude of tables and, although
they provide for writing your own queries and reports, they won't tell
you what data is where. You have to find it on your own. In addition,
whoever had oversight of the project did not seem to enforce any kind
of standards making things even more difficult from a lack of
consistency.

Is there any such thing as a utility which will look at a database and
print out a list of the fields in each table along with their
descriptions (type, length, etc.). Ideally it would also save the data
as an Excel spreadsheet with each table on its own worksheet but I'll
settle for a printout.


Gary J Sibio
(e-mail address removed)
http://home.earthlink.net/~garysibio

There are 10 types of people in this world -- those who understand binary numbers and those who do not.
 
Click Tools, Analyze, Documenter
Click Options to change what you'd like to see in your output. The
documenter will give you one table per page.

Hope that helps!
 
Is there any such thing as a utility which will look at a database and
print out a list of the fields in each table along with their
descriptions (type, length, etc.). Ideally it would also save the data
as an Excel spreadsheet with each table on its own worksheet but I'll
settle for a printout.
Click to expand...

Total Access Analyzer from http://www.fmsinc.com does this very
nicely.

There are some resources at Jeff Conrad's website that won't hit your
pocketbook as hard:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html


John W. Vinson[MVP]
 
Back
Top