References that you may have to set when you work with databases in Access 2002 (870963)


The information in this article applies to:

  • Microsoft Access 2002
kbclone: Q197110
Moderate: Requires basic macro, coding, and interoperability skills.

INTRODUCTION

This article lists the references that you may have to set when you work with databases that are created in Microsoft Access 2002. This article also lists the references that you may have to set when you access other applications from an Access application.

The following topics are covered in this article:
  • Microsoft Access 10.0 Object Library reference
  • Microsoft Office 10.0 Object Library reference
  • Setting a reference to other applications

MORE INFORMATION

Access 2002 allows you to create references to other components. Each component supplies its own set of objects. The object library for the component contains information about the properties and the methods of the objects for the component. The objects are available to Access 2002 only when a reference exists for the objects in the Available References list box in the References dialog box.

To locate the Available References list, follow these steps:
  1. Start the Visual Basic Editor.
  2. On the Tools menu, click References.

    The References dialog box appears.
  3. In the References dialog box, click Available References.
By default, the following references are selected when you create a new Access 2002 database:
  • Microsoft Visual Basic for Applications
  • Microsoft Access 10.0 Object Library
  • OLE Automation
  • Microsoft ActiveX Data Objects 2.1 Library
Note The Visual Basic for Applications references and the Microsoft Access 10.0 Object Library references must always be set. Additionally, the Microsoft ActiveX Data Objects 2.1 Library references may also have to be set.

Visual Basic for Applications Library reference (Vbe6.dll)

The following objects are found in the Visual Basic for Applications Object Library:
  • Debug object
  • Err object
  • Collection object
Note This is not a complete list of the objects that are found in the Visual Basic for Applications Object Library.

Microsoft Access 10.0 Object Library reference (Msacc.olb)

By default, the Microsoft Access 10.0 Object Library reference is set. The following objects and the following 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 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 ADO Ext. 2.7 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.6 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

Microsoft Office 10.0 Object Library Reference (Mso.dll)

Access 2002 also includes the following objects from the Microsoft Office 10.0 Object Library. You can use the following objects if you want to work with objects that are provided by Microsoft Office:
  • CommandBar object
  • FileSearch object
  • Assistant object

Setting a reference to other programs

You can also set a reference to an object library. The reference is supplied by other applications or by other components. You do this when you want to use objects in those libraries for Automation operations in Access. The following list includes some of the applications and some of the object libraries that you can reference:
  Application                     Reference
  ------------------------------------------------------------------------

  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.0 objects    MS Graph 10.0 Object Library (Graph.exe)

REFERENCES

For more information about Access 2002 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 topics returned.
Modification Type:MinorLast Reviewed:9/3/2004
Keywords:kbConfig kbhowto kbProgramming kbinfo KB870963 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.