Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 295194 - Last Review: September 17, 2011 - Revision: 6.0
ADO help does not work if you reference ADO 2.6 object library in Access 2002
This article was previously published under Q295194
Moderate: Requires basic macro, coding, and interoperability
skills.
This article applies to a Microsoft Access database (.mdb) and to a
Microsoft Access project (.adp).
After you add a reference to the ActiveX Data Objects (ADO)
2.6 object library, when you try to bring up context sensitive Help for ADO (by
pressing F1), Help opens but displays a blank window.
The ADO 2.6 help file is not included with the core MDAC
2.6 installation file, mdac_typ.exe. This applies to either downloading
mdac_typ.exe directly from the Microsoft website or installing it from the
installation program of a separate application (such as Microsoft SQL Server
2000).
The ADO 2.6 Help files are included with the ADO 2.6
Software Development Kit (SDK), a separately downloadable file. You can
download the ADO 2.6 SDK from the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6a7d785f-c2e0-471d-a33b-82ad1d514737
(http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6a7d785f-c2e0-471d-a33b-82ad1d514737)
After you install the ADO 2.6 SDK, you can view ADO 2.6 Help in
the
Microsoft Data Access SDK 2.6 program group from your
Start button. However, to make context-sensitive Help available from
within Access, you must follow these steps:
- In the folder where you installed the ADO 2.6 SDK, locate
the files ADO260.chm and ADO260.chi. By default, these files are installed in
the following folder:
C:\Program Files\Microsoft Data Access SDK\Docs\
- Copy the ADO260.chm and ADO260.chi files, and then paste
them to one of the following two folders, depending on the version of Microsoft
Windows that you are running:
For Microsoft Windows 98 and Microsoft Windows Millennium Edition (ME):
C:\Windows\Help
For Microsoft Windows NT and Microsoft Windows 2000:
C:\WINNT\Help
NOTE: The exact folder path may differ if you have installed Windows
to a non-default location.
You can now bring up ADO 2.6
context-sensitive Help from within the Visual Basic Editor.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
Steps to Reproduce the Behavior
- Install Access 2002 on a clean Windows-based computer that
has not had MDAC 2.6 installed.
- Install MDAC 2.6 by installing SQL Server 2000 or install
it from the following Microsoft Web site:
- Open the sample database Northwind.mdb, and then open the
Visual Basic Editor.
- On the Tools menu, click References.
- Add a reference to Microsoft ActiveX Data Objects 2.6 Library.
- Add the following code to a module:
Public Sub TestADO26()
Dim vTest As ADODB.Field
End Sub
- Place your mouse pointer within the word Field, and then press F1.
Note that Help opens but with a
blank gray window.
Note that if you change your ADO reference to 2.5 and then try
the same steps, the appropriate Help topic is displayed.
APPLIES TO
- Microsoft Access 2002 Standard Edition
- Microsoft Data Access Components 2.6
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate