This
article applies to a Microsoft Access database (.mdb) and a Microsoft Access
project (.adp).
Moderate: Requires basic macro,
coding, and interoperability skills.
For a Microsoft Access 2002 version of this article,
see
282397�
(http://support.microsoft.com/kb/282397/
)
.
For a Microsoft Access 2002 version of this article,
see
282397�
(http://support.microsoft.com/kb/282397/
)
.
↑ Back to the top
When you create a new Access database or project by using
Microsoft Office Access 2003, the database may reference the Microsoft ActiveX
Data Objects (ADO) 2.1 Library instead of referencing a newer version of the
ADO Library.
↑ Back to the top
If you create a database in the Microsoft Access 2000 file
format by using Access 2003, ADO 2.1 is referenced to enable backward
compatibility with Access 2000 on computers that do not have Microsoft Data
Access Components (MDAC) 2.7 installed.
Note: If you use Access 2003 to create a database in Access 2002 file
format or in Access 2003 file format, the database correctly references the
Microsoft ADO 2.7 Library instead of referencing the ADO 2.1
Library.
↑ Back to the top
To find the most recent version of ADO that is available on
your computer, follow these steps:
- Start Access 2003.
- On the Help menu, click About
Microsoft Office Access.
- In the About Microsoft Office Access
dialog box, click System Info.
- In the left pane of the System Information
dialog box, expand the Office 2003 Applications node, and then
expand the Microsoft Office Access 2003 node.
- Click Summary.
- In the right pane of the System
Information dialog box, notice the ADO version
information.
This information contains the most recent version of ADO
that is available on your computer.
Note When you open the References dialog box for a
newly created Access database, the database references the older version of the
ADO Library (version 2.1). This behavior makes sure that the Access 2003
database has backward compatibility with earlier versions of Access.
Steps to Reproduce the Behavior
- Start Access 2003.
- Create a new Db1.mdb database.
Note Make sure that the default file format for Access 2003 is set to
Access 2000. - On the Tools menu, point to
Macro, and then click Visual Basic Editor.
- In the Visual Basic Editor, click
References on the Tools menu.
There
is a reference to the ADO 2.1 Library (Msado21.tlb) instead of a reference to
the ADO 2.7 Library (Msado27.tlb).
↑ Back to the top