References that you may have to set when you work with databases in Access 2003 (870962)


The information in this article applies to:

  • Microsoft Office Access 2003
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 you create in Microsoft Office Access 2003. This article also lists the references that you may have to set when you access other applications from an Access 2003 application.

The following topics are covered in this article:
  • Microsoft Access 11.0 Object Library reference
  • Microsoft Office 11.0 Object Library reference
  • Set references to other applications

MORE INFORMATION

Access 2003 lets you 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 only available to Access 2003 when a reference exists for the objects in the Available References list. The Available References list is located 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.
By default, the following references are selected when you create a new Access 2003 database:
  • Visual Basic for Applications
  • Microsoft Access 11.0 Object Library
  • OLE Automation
  • Microsoft DAO 3.6 Object Library
  • Microsoft ActiveX Data Objects 2.5 Library
Note The Visual Basic for Applications reference and the Microsoft Access 11.0 Object Library reference must always be set. Additionally, one of the following references, and possibly both of the following references, may also have to be set:
  • Microsoft DAO 3.6 Object Library
  • Microsoft ActiveX Data Objects 2.5 Library

Microsoft Visual Basic for Applications Object Library reference (Vbe6.dll)

The following objects are found in the Microsoft 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 Microsoft Visual Basic for Applications Object Library.

Microsoft Access 11.0 Object Library reference (Msacc.olb)

By default, the Microsoft Access 11.0 Object Library reference is set. The following objects and the following collections are found in the Microsoft Access 11.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 Object Library reference (Stdole2.tlb)

The following objects are found in the OLE Automation Object Library:
  • StdFont object
  • StdFunctions object
  • StdPicture object

Microsoft DAO 3.6 Object Library reference (Dao360.dll)

The following objects and the following collections are found in the Microsoft DAO 3.6 Object Library:
  • DBEngine object
  • Workspace object and Workspaces collection
  • 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 collection
  • User object and Users collection
  • Container object and Containers collection
  • Document object and Documents collection
  • Properties collection
The Microsoft DAO 3.6 Type Library removes support for obsolete objects, obsolete methods, and obsolete properties. Because obsolete objects, obsolete methods, and obsolete properties are not supported, if you use these constructs while the Microsoft DAO 3.6 Type Library is being used, compile errors may occur in your code.

Microsoft ActiveX Data Objects 2.5 Library reference (Msado25.tlb)

The following objects and the following collections 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

Microsoft ADO Ext. 2.7 for DDL and Security Library reference (Msadox.dll)

The following objects and the following collections are found in the Microsoft ADO Ext. 2.7 for DDL and Security 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 and the following collection are found in the Microsoft Jet and Replication Objects 2.6 Library:
  • Filter object and Filters collection
  • JetEngine object
  • Replica object

Microsoft Office 11.0 Object Library reference (Mso.dll)

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

Set references to other applications

You can also set references to object libraries that are 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 2003. The following list includes some of the applications and some of the object libraries that you can reference.

  Application                            Reference
  ------------------------------------------------------------------------

  Microsoft Office Excel 2003 objects    MS Excel 11.0 Object Library (Excel.exe)
  Microsoft Office Word 2003 objects     MS Word 11.0 Object Library (Msword.olb)
  Microsoft Graph 11.0 objects           MS Graph 11.0 Object Library (Graph.exe)

REFERENCES

For more information about Access 2003 object 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:MajorLast Reviewed:9/17/2004
Keywords:kbProgramming kbConfig kbhowto kbinfo KB870962 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.