Microsoft KB Archive/169719

= OFF97: Error in Macro Referencing Remote Data Objects =

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.

