Microsoft KB Archive/169719
Article ID: 169719
Article Last Modified on 1/19/2007
- Microsoft Excel 97 Standard Edition
- Microsoft Word 97 Standard Edition
- Microsoft PowerPoint 97 Standard Edition
- Microsoft Access 97 Standard Edition
- Microsoft Office 97 Standard Edition
This article was previously published under Q169719
If you run a macro that uses objects from the Microsoft Remote Data Object 2.0 library, you may receive the following error message:
This behavior occurs because, by design, Visual Basic for Applications macros cannot directly use objects in the Microsoft Remote Data Object 2.0 library.
NOTE: The Visual Basic Editor allows you to create a reference to the Microsoft Remote Data Object 2.0 library. The Auto List Members list works as you create the macro code. However, when you run the macro, you receive the error message mentioned in the "Symptoms" section.
To resolve this behavior, remove any code that references objects in the Microsoft Remote Data Object 2.0 library.
You may be able to run macros that use objects from the Microsoft Remote Data Object 2.0 library, if you have the following products installed on your computer:
- Microsoft Visual Basic Enterprise Edition for Windows, version 5.0
- Microsoft Visual C++, 32-bit Enterprise Edition, version 5.0
If you are successful in running your macros with these products installed, Microsoft Technical Support cannot assist you with your macros.
If you want to use Remote Data Object functionality, use the new client/server connection mode called ODBCDirect, a method which is supported. ODBCDirect establishes a connection directly to an Open Database Connectivity (ODBC) data source without loading the Microsoft Jet database engine into random access memory (RAM). ODBCDirect is useful in situations where specific features of ODBC are required. ODBCDirect requires that you have the Microsoft Remote Data Object 2.0 library on your computer, but it is not necessary to refer to it. However, you must refer to the Microsoft DAO 3.5 Object Library.
For more information about ODBCDirect, click the Office Assistant in the Visual Basic Editor, type ODBCDirect, click Search, and then click to view the "What's New in DAO?" topic.
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
120802 Office: How to Add/Remove a Single Office Program or Component
Additional query words: XL97 rdo xlvbainfo WD97 WD2000 429 can t
Keywords: kberrmsg kbprb kbprogramming KB169719