Microsoft KB Archive/135501

= OFF95: DAO Entry Does Not Appear in Help =

Article ID: 135501

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Office 95 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q135501





SYMPTOMS
If you install the Data Access component of Microsoft Office, version 7.0, you may not see a listing for Data Access Objects (DAO) on the Help Contents tab for Microsoft Excel. Additionally, the Help file for DAO may not be listed in the File Options dialog box (to access this dialog box, click the Options button on the Find tab and then click Files).



CAUSE
This problem occurs, for example, when you do a Custom installation of any of the Microsoft products listed at the beginning of this article and you choose not to install the Data Access component, which includes the Help file for Data Access Objects. However, even when you add the Help file through a maintenance setup, the Help file may not be listed in either the Contents tab or the File Options dialog box because the index reference to the DAO Help file is not updated correctly.

Also, when you run a Help file, you can use the Find Setup Wizard (the first time you click the Find tab) to create a list that contains every word from the Help files for your applications. When the word list is created, you can click the Options button on the Find tab to select the options such as which files to search. However, the list of files to search may not contain all of the Help files that are on your computer.



RESOLUTION
If you have the DAO Help file installed, but you cannot see it listed anywhere in Microsoft Excel Help, do the following:

 Quit Microsoft Excel if it is running. In a text editor such as Microsoft WordPad, open the Mainxl.cnt file (this file should be located in your Microsoft Excel folder).  Insert the following text, just below the other entries that begin with ":Index Microsoft Excel ...": :Index DAO Help=dao.hlp  Close the Mainxl.cnt file and save the changes. Restart Microsoft Excel, and click Microsoft Excel Help Topics on the Help menu.</ol>

Microsoft Data Access Objects (DAO) should be listed on the Contents tab. If you click the Find tab, click the Options button, and then click the Files button, you should see the DAO Help file listed.

<div class="moreinformation_section">

MORE INFORMATION
For more information about missing files when you build a Help index, please see the following article in the Microsoft Knowledge Base:

134734 OFF95: Help Files Not Available When Building Index

Additional query words: xl7

Keywords: KB135501

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.