Microsoft KB Archive/109404

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:

1. 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:

2. Save and then close the MSACCESS.INI file. Start Microsoft Access and open the database ANALYZER.MDA.
3. 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.
4. Save and then close the table, and then open the module Object Analyzer.
5. Find the function DumpTableInfo().
6. 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.
7. Save and close the module, and then quit Microsoft Access.

8. 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

         ;analyzer.mda= 

   line in the [Libraries] section of the file. The modified line will be:

9. Save and then close the file.

REFERENCES

For more information about the Object Analyzer, see the ANALYZER.TXT file that comes with Microsoft Access version 1.1 or the README.TXT file that comes with Microsoft Access version 1.0.

Additional query words:

Keywords : kbusage
Issue type : kbhowto
Technology :

Last Reviewed: November 4, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use.