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 2002This article was previously published under Q282397 For a Microsoft Office Access 2003 version of this
article, see
825440
(http://support.microsoft.com/kb/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). SYMPTOMS 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. CAUSE 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. MORE INFORMATION 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
| Article Translations
|
Back to the top
