Microsoft KB Archive/283115

= List of references that you must set when you work with Access 2002 =

Article ID: 283115

Article Last Modified on 8/19/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This 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.



For a Microsoft Access 97 version of this article, see 175484.

For a Microsoft Access 2000 version of this article, see 197110.



SUMMARY
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:
 * Microsoft Access 10.0 Object Library Reference (set by default)


 * Microsoft Office 10.0 Object Library Reference (included in the package)


 * Setting a Reference to Other Applications


 * Setting a Reference to DAO for Different Versions of Microsoft Access


 * Setting a Reference to DAO for Other Applications That Use Microsoft Access



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


 * Microsoft Access 10.0 Object Library


 * OLE Automation


 * Microsoft ActiveX Data Objects 2.1 Library

The references that are selected by default at the time that a new Microsoft Access database is created in Access 2002 format in Access 2002 are:
 * Visual Basic for Applications


 * Microsoft Access 10.0 Object Library


 * OLE Automation


 * Microsoft ActiveX Data Objects 2.5 Library


 * Microsoft Office XP Web Components

Visual Basic for Applications Library Reference (VBE6.DLL)
The following objects are found in the Visual Basic for Applications Object Library:
 * Debug Object


 * ErrObject Object


 * Collection object

Microsoft Access 10.0 Object Library Reference (MSACC.OLB)
The following objects and collections are found in the Microsoft Access 10.0 Object Library:
 * Application object


 * Form object and Forms collection


 * Report object and Reports collection


 * Control object and Controls collection


 * Module object and Modules collection


 * Reference object and References collection


 * DoCmd object


 * Screen object

OLE Automation Library Reference (STDOLE2.TLB)
The following objects are found in the OLE Automation Object Library:
 * StdFont object


 * StdFunctions object


 * StdPicture object

Microsoft ActiveX Data Objects 2.1 Library Reference (MSADO21.TLB)
The following objects are found in the Microsoft ActiveX Data Objects 2.1 Library:
 * Command object


 * Connection object


 * Error object and Errors collection


 * Field object and Fields collection


 * Parameter object and Parameters collection


 * Property object and Properties collection


 * Recordset object

Microsoft ActiveX Data Objects 2.5 Library Reference (MSADO15.DLL)
The following objects are found in the Microsoft ActiveX Data Objects 2.5 Library:
 * Command object


 * Connection object


 * Error object and Errors collection


 * Field object and Fields collection


 * Parameter object and Parameters collection


 * Property object and Properties collection


 * Recordset object


 * Record object


 * Stream object

Microsoft ADO Ext. 2.5 for DDL and Security Library Reference (MSADOX.DLL)
The following objects are found in the Microsoft ADO Extensions Library:
 * Catalog object


 * Column object and Columns collection


 * Group object and Groups collection


 * Index object and Indexes collection


 * Key object and Keys collection


 * Procedure object and Procedures collection


 * Property object and Properties collection


 * Table object and Tables collection


 * User object and Users collection


 * View object and Views collection

Microsoft Jet and Replication Objects 2.5 Library Reference (MSJRO.DLL)
The following objects are found in the Microsoft Jet and Replication Objects Library:
 * Filter object and Filters collection


 * JetEngine object


 * Replica object

The Microsoft DAO 3.6 Object Library (DAO360.DLL)
The following objects and collections are found in the DAO object library:
 * DBEngine object


 * Workspace object and Workspaces collections


 * Error object and Errors collection


 * Database object and Databases collection


 * TableDef object and TableDefs collection


 * Field object and Fields collection


 * Index object and Indexes collection


 * QueryDef object and QueryDefs collection


 * Parameter object and Parameters collection


 * Relation object and Relations collection


 * Recordset object and Recordsets collection


 * Group object and Groups collections


 * User object and Users collection


 * Container object and Containers collection


 * Document object and Documents collection


 * Properties collection

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 Access
If 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 Access
If 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.
 * CommandBar object


 * FileSearch object


 * Assistant object

Setting a Reference to other applications
You 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:
 * ChartSpace Object


 * DataSourceControl Object


 * PivotTable List Object


 * Spreadsheet Object

