Microsoft KB Archive/175484

= ACC97: References That You Must Set When You Work with Microsoft Access =

Article ID: 175484

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q175484



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



SUMMARY
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 97 Object Library References Set by Default
 * Microsoft Office 8.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 box in the References box on the Tools menu.

Microsoft Access 97 Object Library References Set by Default
The following object libraries are set by default when you install Microsoft Access 97:

  The Microsoft Access 8.0 Object Library (MSACC8.OLB)

The following objects and collections are found in the Microsoft Access 8.0 Object Library:    - Application object - Form object - Forms collection - Report object - Reports collection - Control object - Controls collection - Module object - Modules collection - Reference object - References collection - DoCmd object - Screen object   The Visual Basic for Applications Object Library (VBA332.dll)

The following objects are found in the Visual Basic for Applications Object Library:    - Debug object - Err object - Collection object   The Microsoft DAO 3.5 Object Library (DAO350.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 NOTE: In order to ease the conversion of applications that use older objects, methods, and properties, you can use the following type libraries instead of DAO350.dll:     DAO 2.5 type library   (DAO2532.tlb) DAO 3.5 type library  (DAO2535.tlb) These type libraries define the properties and methods that DAO can use. The DAO 2.5 type library is backward compatible with earlier versions of the Microsoft Jet database engine and supports all previous objects, methods, and properties. Use this type library if you want existing DAO code to work with Microsoft Jet database engine 3.0 or 3.5 without conversion. 

Microsoft Office 8.0 Object Library Reference Included in the Package
Microsoft Access 97 also includes the Microsoft Office 8.0 Object Library. This is included for users who want to work with objects provided by Microsoft Office.   The Microsoft Office 8.0 Object Library (MS097.DLL)

The following objects are found in the Office 8.0 Object Library: <pre class="fixed_text">   - CommandBar object - FileSearch object - Assistant object </li></ul>

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. <pre class="fixed_text"> Application                     Reference Microsoft Excel 97 objects     MS Excel 8.0 Object Library (EXCEL8.olb) Microsoft Word 97 objects      MS Word 8.0 Object Library (MSWORD8.olb) Microsoft Office Binder control MS Binder 8.0 Object Library (MSBDR8.olb) Microsoft Graph 5.0            MS Graph 5.0 Object Library (GREN50.olb) Microsoft Graph 8.0            MS Graph 8.0 Object Library (GRAPH8.olb)

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. <pre class="fixed_text"> 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

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. <pre class="fixed_text"> 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.5 Object Library Microsoft Excel 97                Microsoft DAO 3.5 Object Library Microsoft Word 97                 Microsoft DAO 3.5 Object Library Microsoft Project 4.1             Microsoft DAO 3.0 Object Library Microsoft Project 95              Microsoft DAO 3.0 Object Library Microsoft IIS 3.0                 Microsoft DAO 3.5 Object Library

<div class="references_section">