Hi Frank,
Here are three past posts on this subject by the legendary MVP Duane Hookom which should hopefully
help a bit on this subject. Incidentally, what type of information are you looking for when you run
the documentor report? I have some Add-Ins that do specific "database documenting" tasks.
Here's the first:After you run the documenter, you can create a link to the table that
contains all the property values. The table connection on my PC is
DATABASE=C:\Documents and Settings\Duane Hookom\Application
Data\Microsoft\Access\ACWZUSRT.MDT;TABLE=doc_tblObjects
You can then create a crosstab with SQL like:
TRANSFORM First(doc_tblObjects_2.Extra1) AS FirstOfExtra1
SELECT doc_tblObjects.Name AS TableName, doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType, doc_tblObjects_1.Extra3 AS FieldSize
FROM doc_tblObjects AS doc_tblObjects_2 INNER JOIN (doc_tblObjects AS
doc_tblObjects_1 INNER JOIN doc_tblObjects ON doc_tblObjects_1.ParentID =
doc_tblObjects.ID) ON doc_tblObjects_2.ParentID = doc_tblObjects_1.ID
WHERE (((doc_tblObjects_1.TypeID)=11))
GROUP BY doc_tblObjects.Name, doc_tblObjects_1.Name,
doc_tblObjects_1.Extra2, doc_tblObjects_1.Extra3
PIVOT doc_tblObjects_2.Name In ("Caption:","Description:");
--
Duane Hookom
MS Access MVP
Here's the second:
I also find the documenter a bit too structured. The good news is that you
can use all the generated information however you want. All of the
information (Access 2000 and later) is stored in a table that you can link
to. On my XP system, the table and file the connection is:
DATABASE=C:\Documents and Settings\Duane Hookom\Application
Data\Microsoft\Access\ACWZUSRT.MDT;TABLE=doc_tblObjects
The table doc_tblObjects can be self-joined to create your own
queries/reports.
A simple query of tables, field, types, and sizes is:
SELECT doc_tblObjects.Name AS TableName,
doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType,
doc_tblObjects_1.Extra3 AS FieldSize
FROM doc_tblObjects AS doc_tblObjects_1
INNER JOIN doc_tblObjects ON doc_tblObjects_1.ParentID =
doc_tblObjects.ID
WHERE (((doc_tblObjects_1.TypeID)=11));
I have also created crosstabs from the table that list all fields as Row
Headings and tables as Column Headings. This provides a cross-reference of
which fields are common to which tables.
--
Duane Hookom
MS Access MVP
Here's the third:
You can always roll your own report. In Access 2000, all of your objects and
properties from the documenter are automatically saved in a table that you
can link to. On my PC the connection to the table is:
DATABASE=C:\WINDOWS\Application
Data\Microsoft\Access\ACWZUSR.MDT;TABLE=doc_tblObjects
After you run the documenter, link to the table and create a new query with
the following SQL:
TRANSFORM First(doc_tblObjects_2.Extra1) AS FirstOfExtra1
SELECT doc_tblObjects.Name AS TableName,
doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType,
doc_tblObjects_1.Extra3 AS FieldSize
FROM (doc_tblObjects AS doc_tblObjects_2
INNER JOIN doc_tblObjects AS doc_tblObjects_1
ON doc_tblObjects_2.ParentID = doc_tblObjects_1.ID)
INNER JOIN doc_tblObjects
ON doc_tblObjects_1.ParentID = doc_tblObjects.ID
WHERE doc_tblObjects_1.TypeID=11
GROUP BY doc_tblObjects.Name, doc_tblObjects_1.Name,
doc_tblObjects_1.Extra2, doc_tblObjects_1.Extra3
PIVOT doc_tblObjects_2.Name In ("Description:");
[/QUOTE][/QUOTE][/QUOTE]
Hope that helps a little,
