Microsoft KB Archive/109404

{|
 * width="100%"|

ACC1x: How to Make the Analyzer Include Field Descriptions

 * }

Q109404

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SUMMARY
The Object Analyzer utility that comes with Microsoft Access does not include field descriptions in its output. However, you can make the Analyzer include field descriptions by making some modifications to the utility.

MORE INFORMATION
To make the Analyzer include field descriptions in its output you need to modify the table RLTables and the function DumpTableInfo in the ANALYZER.MDA library.

The following steps describe how to make the necessary modifications:

  Use Windows Notepad (or any other text editor) to open the MSACCESS.INI file that is in your Windows directory. If the line      analyzer.mda= exists in the [Libraries] section of the MSACCESS.INI file, put a semicolon at the beginning of the line. The modified line will be:  Save and then close the MSACCESS.INI file. Start Microsoft Access and open the database ANALYZER.MDA. Open the RLTables table in Design view, and add a field called Description to the table. The field should have a data type of Text, with a length of 255 characters. Save and then close the table, and then open the module Object Analyzer. Find the function DumpTableInfo. Add the lines of code listed below to the function. Note that the lines to be added begin with the characters $$.

NOTE: In the following sample code, an underscore (_) is used as a line-continuation character. Remove the underscore from the end of the line when re-creating this code in Access Basic. Save and close the module, and then quit Microsoft Access.  Use Windows Notepad (or any other text editor) to open the MSACCESS.INI file that is in your Windows directory. Remove the semicolon from the beginning of the <pre class="FIXEDTEXT">     ;analyzer.mda= line in the [Libraries] section of the file. The modified line will be: </li> Save and then close the file.</li></ol>