ACC2000: References to Set When Working with Microsoft Access

ID: Q197110

The information in this article applies to:

Microsoft Access 2000

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

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 9.0 Object Library Reference (set by default)

Microsoft Office 9.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

MORE INFORMATION

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 (MS09.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)

REFERENCES

For more information about references, search the Help Index for "References collection," or ask the Microsoft Access 2000 Office Assistant.

Additional query words: inf


Keywords          : kbdta IntpOlea 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: June 14, 1999