Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 282397 - Last Review: August 10, 2004 - Revision: 4.0
ActiveX Data Objects 2.1 is referenced by default instead of ActiveX Data Objects 2.5 in Access 2002
This article was previously published under Q282397
For a Microsoft Office Access 2003 version of this
article, see
825440Â
(http://kbalertz.com/Feedback.aspx?kbNumber=825440/
)
.
Moderate: Requires basic macro,
coding, and interoperability skills.
This article applies to a Microsoft
Access database (.mdb) and to a Microsoft Access project (.adp).
When you create a new Microsoft Access 2002 database or
project, you find that the database references the ActiveX Data Objects (ADO)
2.1 library, instead of a newer version of this library.
When you use Access 2002 to create an Access 2000 database,
ADO 2.1 is referenced to enable backward compatibility with Access 2000 on
computers that do not have MDAC 2.5 installed.
However, if you use
Access 2002 to create an Access 2002 database or project, ADO 2.5 is referenced
instead of ADO 2.1. This is because MDAC 2.5 is installed when Office XP is
installed.
In Access 2002, when you select
About Microsoft Access on the
Help menu, and then click
System Info, the
Microsoft System Information dialog box is opened. If you expand the
Office 10 Applications node, and then click the
Microsoft Access 10 node, the information in the right window pane lists ADO version
2.5 (or possibly later). However, when you open the
References dialog box, you find that the new database references the older
2.1 version of this library. This behavior is by design in order to ensure that
Access 2002 databases are backward compatible with earlier versions of
Microsoft Access.
Steps to Reproduce the Behavior
- In Access 2002, create a new database called Db1.mdb.
- On the Tools menu, point to Macro, and then click Visual Basic Editor.
- In the Visual Basic Editor, click References on the Tools menu.
Note that there is a reference to the Microsoft ActiveX Data Objects 2.1 Library (Msado21.tlb).
APPLIES TO
- Microsoft Access 2002 Standard Edition
| kbtshoot kbprb kbado KB282397 |
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