Article ID: 283115 - Last Review: August 19, 2004 - Revision: 4.1 List of references that you must set when you work with Access 2002This article was previously published under Q283115 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
For a Microsoft Access 2003 version of this article, see 825796
(http://support.microsoft.com/kb/825796/
)
.
For a Microsoft Access 97 version of this article, see 175484
(http://support.microsoft.com/kb/175484/
)
.
For a Microsoft Access 2000 version of this article, see 197110
(http://support.microsoft.com/kb/197110/EN-US/
)
.
On This PageSUMMARY
This article lists the references that you must set when you are working
with databases that you create in Microsoft Access or when you access
information in Microsoft Access databases from other applications.
The following topics are covered in this article:
MORE INFORMATION
Microsoft Access includes several components, each of which supplies its
own set of objects. The component's object library contains information
about its objects, properties, and methods. The objects
are available to Microsoft Access only if a reference exists for the
objects in the Available References box in the References dialog box (on the Tools menu).
The references that are selected by default at the time that a new Microsoft Access database is created in Access 2000 format in Access 2002 are:
Visual Basic for Applications Library Reference (VBE6.DLL)The following objects are found in the Visual Basic for Applications Object Library:
Microsoft Access 10.0 Object Library Reference (MSACC.OLB)The following objects and collections are found in the Microsoft Access 10.0 Object Library:
OLE Automation Library Reference (STDOLE2.TLB)The following objects are found in the OLE Automation Object Library:
Microsoft ActiveX Data Objects 2.1 Library Reference (MSADO21.TLB)The following objects are found in the Microsoft ActiveX Data Objects 2.1 Library:
Microsoft ActiveX Data Objects 2.5 Library Reference (MSADO15.DLL)The following objects are found in the Microsoft ActiveX Data Objects 2.5 Library:
Microsoft ADO Ext. 2.5 for DDL and Security Library Reference (MSADOX.DLL)The following objects are found in the Microsoft ADO Extensions Library:
Microsoft Jet and Replication Objects 2.5 Library Reference (MSJRO.DLL)The following objects are found in the Microsoft Jet and Replication Objects Library:
The Microsoft DAO 3.6 Object Library (DAO360.DLL)The following objects and collections are found in the DAO object library:
The DAO 3.6 type library removes support for obsolete objects,
methods, and properties. Because they are not supported, use of these
constructs while the DAO 3.6 type library is in use will cause compile
errors in your code.
Setting a Reference to DAO for different versions of Microsoft AccessIf you have more than one version of Microsoft Access on your computer, you may need to reference different versions of the Microsoft DAO Object Library. The following list gives the version of the application and the version of DAO that you should use.Version of Microsoft Access Version(s) of DAO ---------------------------------------------------------------------- Microsoft Access 1.0 Microsoft DAO 2.5/3.0 Compatibility Microsoft Access 1.1 Microsoft DAO 2.5/3.0 Compatibility Microsoft Access 2.0 Microsoft DAO 2.5/3.0 Compatibility Microsoft Access 7.0 Microsoft DAO 3.0 Object Library Microsoft Access 97 Microsoft DAO 3.5 Object Library Microsoft Access 2000 Microsoft DAO 3.6 Object Library Microsoft Access 2002 Microsoft DAO 3.6 Object Library Setting a Reference to DAO for Other Applications That Use Microsoft AccessIf you are using other applications that communicate with different versions of Microsoft Access, ensure that the version of DAO in the application that you are using can communicate with the version of DAO in your version of Microsoft Access. The following list gives the version of DAO in other applications.Application DAO ---------------------------------------------------------------------- Visual Basic 4.0 (16-bit) Microsoft DAO 2.5/3.0 Compatibility Visual Basic 4.0 (32-bit) Microsoft DAO 3.0 Object Library Visual Basic 5.0 Microsoft DAO 3.5x Object Library Visual Basic 6.0 Microsoft DAO 3.5x Object Library Microsoft Excel 97 Microsoft DAO 3.5x Object Library Microsoft Excel 2000 Microsoft DAO 3.6 Object Library Microsoft Word 97 Microsoft DAO 3.5x Object Library Microsoft Word 2000 Microsoft DAO 3.6 Object Library Microsoft Project 4.1 Microsoft DAO 3.0 Object Library Microsoft Project 95 Microsoft DAO 3.0 Object Library Microsoft Project 2000 Microsoft DAO 3.6 Object Library Microsoft IIS 3.0/4.0 Microsoft DAO 3.5x Object Library Microsoft Excel 2002 Microsoft DAO 3.6 Object Library Microsoft Word 2002 Microsoft DAO 3.6 Object Library Microsoft Project 2002 Microsoft DAO 3.6 Object Library Microsoft Powerpoint 2002 Microsoft DAO 3.6 Object Library Microsoft Office 10.0 Object Library Reference (MSO.DLL)Microsoft Access also includes the Microsoft Office 10.0 Object Library. This is included for users who want to work with objects provided by Microsoft Office.
Setting a Reference to other applicationsYou can also set references to object libraries supplied by other applications or components when you want to use objects in those libraries for Automation operations in Microsoft Access. The following list gives some of the applications and the object libraries that you can reference.Application Reference ------------------------------------------------------------------------ Microsoft Excel 2000 objects MS Excel 9.0 Object Library (EXCEL9.OLB) Microsoft Word 2000 objects MS Word 9.0 Object Library (MSWORD9.OLB) Microsoft Office Binder control MS Binder 9.0 Object Library (MSBDR9.OLB) Microsoft Graph 9.0 objects MS Graph 9.0 Object Library (GRAPH9.OLB) Microsoft Excel 2002 objects MS Excel 10.0 Object Library (EXCEL.EXE) Microsoft Word 2002 objects MS Word 10.0 Object Library (MSWORD.OLB) Microsoft Graph 10 objects MS Graph 10.0 Object Library (GRAPH.EXE) Microsoft PowerPoint 2002 MS PowerPoint 10.0 Object Library (MSPPT.OLB) Microsoft Office XP Web Components (OWC10.DLL)The following objects are found in the Microsoft Office XP Web Components object library:
REFERENCESFor more information about references, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type references collection in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Back to the top
|
