United States

Change

All Microsoft Sites

Help and Support

Article ID: 870962 - Last Review: September 17, 2004 - Revision: 1.3

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

View products that this article applies to.

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

Back to the top

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:

Start the Visual Basic Editor.
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

Back to the top

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.

Back to the top

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

Back to the top

OLE Automation Object Library reference (Stdole2.tlb)

The following objects are found in the OLE Automation Object Library:

StdFont object
StdFunctions object
StdPicture object

Back to the top

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.

Back to the top

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

Back to the top

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

Back to the top

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

Back to the top

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

Back to the top

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)

Back to the top

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.

Back to the top