OFF97: Error in Macro Referencing Remote Data Objects (169719)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Word 97 for Windows
  • Microsoft PowerPoint 97 for Windows
  • Microsoft Access 97
  • Microsoft Office 97 for Windows
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

Modification Type:MinorLast Reviewed:9/13/2006
Keywords:kberrmsg kbprb kbProgramming KB169719
©2004 Microsoft Corporation. All rights reserved.