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 |
Back to the top
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 |
Back to the top
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 |
Back to the top
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 |
Back to the top
OLE Automation 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 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 |
Back to the top
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 |
Back to the top
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 |
Back to the top
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 |
Back to the top
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.
Back to the top
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
Back to the top
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
Back to the top
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 |
Back to the top
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)
Back to the top
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 |
Back to the top
For 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.
Back to the top
