Table documentation

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Does anyone know how to output the table documenter
information to any format other than a printed file? I
tried printing to a file but that turns out to be the
jibberish that a only a printer can read. I need a readable
output that I can manipulate.

Thanks
 
This depends on your version of Access. Access 97 and earlier allow you to
save the results as a file. Access 2000 and later automatically save the
information in a wizard mdb. On my system, the file and table is:
DATABASE=C:\Documents and Settings\Duane Hookom\Application
Data\Microsoft\Access\ACWZUSRT.MDT;TABLE=doc_tblObjects
To get a query of TableName, FieldName, FieldType, FieldSize use this sql:
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));
 
Back
Top