Microsoft KB Archive/169719

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


Article ID: 169719

Article Last Modified on 1/19/2007



APPLIES TO

  • 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

SYMPTOMS

If you run a macro that uses objects from the Microsoft Remote Data Object 2.0 library, you may receive the following error message:

Run-time error '429'
ActiveX component can't create object

CAUSE

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.

RESOLUTION

To resolve this behavior, remove any code that references objects in the Microsoft Remote Data Object 2.0 library.

MORE INFORMATION

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.

REFERENCES

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