The MDT file extensions don't show so I would find the folder and type in
*.mdt
to bring up the file name.
Prior to Access 2000, you were offered the ability to save the results of
documentor in a table.

I have used the results of the documenter to re-create forms on the fly from
scratch. The doc_tblObjects table can contain all the information required
to create your form on-the-fly. It wasn't easy but I needed this to run as
an MDE add-in to create a form with controls etc in a user's mdb file.

--
Duane Hookom
MS Access MVP
--

"Jeff Conrad" wrote in message
...
Hi Duane,

I can understand why it is probably not documented anywhere; everything
could get messed up just as
you say!

I did not even realize there were these MDT files in various profiles.

Incidentally, this must be something from Access 2000 onward.
I could only find one MDT file on a computer running Access 97 called
Wzdat80.mdt.
That did not have this type of information you discussed.
I wonder if that information is stored somewhere else in Access 97??

Also, I found something interesting.
On a Access 2000 machine I had trouble actually linking to the MDT file.
When I browsed to the correct folder no MDT files showed up because it was
not one of the listed
file types on the dialog box. I thought there would be an option for "All
Files", but there was no
such option. With the correct folder showing I actually had to type in the
name of the MDT before I
could link to it. Strange. Did you have the same issue?

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Duane Hookom" wrote in message
...
Hi Jeff,
I found this quite a while ago but don't recall how. I knew there would
be a
table created in an MDT file and just searched. You can open the MDT
directly and see lots of interesting stuff but none of it is documented
and
if you mess up something, you may have wizards or builders BREAK.

Regarding the documenter, I have created a crosstab of field names as
row
headings and table names as column headings and size a the value to see
where fields are common to various tables.

--
Duane Hookom
MS Access MVP


"Jeff Conrad" wrote in message
...
How in the world do you come up with this stuff Duane??!
That is VERY slick!
Is there some documentation on this somewhere you found?

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Duane Hookom" wrote in message
...
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_tblOb jects
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


"W Garrard" wrote in message
...
Hi All,
I have to document an inherited set of MSAccess 2000 files and it
would be
very helpful if I could customize the output from the tables
documentor.
I
would like to have the table report output include the "field
description"
(info visible in table design view) and the "caption" in addition
to
the
default info (e.g., field name, data type, and data size).

I assume the only way to do this is using VBA. I am pretty good
at
modifying existing VBA code if someone can point me to a relevant
example
for this. Of course, I would love a nonVBA option for doing this.
Can
anyone point me to a solution?

Also, it would be worth upgrading to a newer version of MSAccess
if
the
documentor output was customizable. Anyone know this?

Thanks in advance,
wg