OFF97: Error in Macro Referencing Remote Data Objects

• Microsoft Visual Basic for Applications included with:
• Microsoft Excel 97 for Windows
• Microsoft Word 97 for Windows
• Microsoft PowerPoint 97 for Windows
• Microsoft Access 97

SYMPTOMS

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

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

CAUSE

This behavior occurs because 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.

RESOLUTION

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

STATUS

This behavior is by-design of Microsoft Excel.

MORE INFORMATION

If you want to use Remote Data Object functionality, use the new client/server connection mode called ODBCDirect. ODBCDirect establishes a connection directly to an Open Database Connectivity (ODBC) data source without loading the Microsoft Jet database engine into random access memory. 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 make a reference to it. However, you must make a reference 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:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office
               Program or Component