Generating a Table of Databse Properties (Tools->Analyze->Documenter)

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Does anyone know of any code or tools that generate a table (or spreadsheet)
of a table's properties. Basically something similar to
Tools->Analyze->Documenter, except instead of a report, a table of
properties. I took a look at www.mvps.org and tried some searches in
Google, but did not turn up anything.

Thanks!

Don
 
When you run the Documenter, you create a table in an MDT file that you can
link to:
DATABASE=C:\Documents and Settings\Duane Hookom\Application
Data\Microsoft\Access\ACWZUSRT.MDT;TABLE=doc_tblProperties
You can create a query to get the table and field names:
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));
 
You could probably start it with DoCmd.RunCmd acCmdDocumenter (I think). If
you want all of this automated, then consider Allen Browne's recommendation.
 
Back
Top