Microsoft Access includes several components, each of which
supplies its own set of objects. The component's object library contains
information about the component's objects and their properties and methods. The
objects are available to Microsoft Access only if a reference exists for the
objects in the Available References list box in the References box on the Tools
menu.
The references that are selected by default at the time a new
Microsoft Access 2000 database is created are:
- Visual Basic for Applications
- Microsoft Access 9.0 Object Library
- OLE Automation
- Microsoft ActiveX Data Objects 2.1 Library
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 9.0 Object Library Reference (MSACC9.OLB)
The following objects and collections are found in the Microsoft
Access 9.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 (MSADO15.DLL)
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.1 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.1 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 causes 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
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 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 Office 9.0 Object Library Reference (MSO9.DLL)
Microsoft Access 2000 also includes the Microsoft Office 9.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)