Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
type library missing
- Thread starter rry2k
- Start date
Hi Russ ,
Here is a copy of a Microsoft Knowledge base article ,
Which May be of Some Help To You.
ACC97: References That You Must Set When You Work with Microsoft Access
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:
- 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
------------------------------------------------------------
MS Excel 97 objects MS Excel 8.0 Obj Lib (EXCEL8.olb)
MS Word 97 objects MS Word 8.0 Obj Lib (MSWORD8.olb)
MS Office Binder control MS Binder 8.0 Obj Lib (MSBDR8.olb)
MS Graph 5.0 MS Graph 5.0 Obj Lib (GREN50.olb)
MS Graph 8.0 MS Graph 8.0 Obj Lib (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.
Version of MS 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.
Application DAO
-----------------------------------------------------------
Visual Basic 4.0 (16-bit) MS DAO 2.5/3.0 Compatibility
Visual Basic 4.0 (32-bit) MS DAO 3.0 Object Library
Visual Basic 5.0 MS DAO 3.5 Object Library
Microsoft Excel 97 MS DAO 3.5 Object Library
Microsoft Word 97 MS DAO 3.5 Object Library
Microsoft Project 4.1 MS DAO 3.0 Object Library
Microsoft Project 95 MS DAO 3.0 Object Library
Microsoft IIS 3.0 MS DAO 3.5 Object Library
REFERENCES
For more information about references, search the Help Index for "References collection," or ask the Microsoft Access 97 Office Assistant.
Below is the Link For the Knowledge Base Article.
HTH
Animaniac
>
:O>
"If at first You don't Succeed , USE a bigger Hammer"
Here is a copy of a Microsoft Knowledge base article ,
Which May be of Some Help To You.
ACC97: References That You Must Set When You Work with Microsoft Access
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:
- 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
------------------------------------------------------------
MS Excel 97 objects MS Excel 8.0 Obj Lib (EXCEL8.olb)
MS Word 97 objects MS Word 8.0 Obj Lib (MSWORD8.olb)
MS Office Binder control MS Binder 8.0 Obj Lib (MSBDR8.olb)
MS Graph 5.0 MS Graph 5.0 Obj Lib (GREN50.olb)
MS Graph 8.0 MS Graph 8.0 Obj Lib (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.
Version of MS 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.
Application DAO
-----------------------------------------------------------
Visual Basic 4.0 (16-bit) MS DAO 2.5/3.0 Compatibility
Visual Basic 4.0 (32-bit) MS DAO 3.0 Object Library
Visual Basic 5.0 MS DAO 3.5 Object Library
Microsoft Excel 97 MS DAO 3.5 Object Library
Microsoft Word 97 MS DAO 3.5 Object Library
Microsoft Project 4.1 MS DAO 3.0 Object Library
Microsoft Project 95 MS DAO 3.0 Object Library
Microsoft IIS 3.0 MS DAO 3.5 Object Library
REFERENCES
For more information about references, search the Help Index for "References collection," or ask the Microsoft Access 97 Office Assistant.
Below is the Link For the Knowledge Base Article.
HTH
Animaniac
>
:O> "If at first You don't Succeed , USE a bigger Hammer"
- Thread starter
- #3
I am unable to add the Microsoft DAO 3.6 Object Library! Anamaniac, although that was a very thorough answer, I am not sure that you really answered his question. How do you get the library if it is not in the references list?
Sera
I often believe that...
My computer is possessed!
Sera
I often believe that...
My computer is possessed!
I am unable to add the Microsoft DAO 3.6 Object Library! Anamaniac, although that was a very thorough answer, I am not sure that you really answered his question. How do you get the library if it is not in the references list?
Sera
I often believe that...
My computer is possessed!
Sera
I often believe that...
My computer is possessed!
Oh good I posted twice. That is nice. Anyway I have found a fix for my problem. And since I found this thread through the search I figured that I would post the solution. The solution can be found in the Microsoft Knowledge Base in Article:
Basically I needed to register the DAO360.DLL file. But if that is not your problem there are four other fixes available to try!
Hope this helps someone! Sera
I often believe that...
My computer is possessed!
Basically I needed to register the DAO360.DLL file. But if that is not your problem there are four other fixes available to try!
Hope this helps someone! Sera
I often believe that...
My computer is possessed!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
