Microsoft KB Archive/291301

= &quot;ActiveX component can't create object&quot; error message when you use Data Access Objects version 3.0 (DAO 3.0) =

Article ID: 291301

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q291301



For a Microsoft Excel 2000 version of this article, see 213577.

For a Microsoft Excel 97 version of this article, see 157436.



SYMPTOMS
When you use Microsoft Data Access Objects version 3.0 (DAO 3.0) with the products listed at the beginning of this article, you may receive the following error message:

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



CAUSE
This error message occurs when both of the following conditions are true:
 * You are referencing the DAO 3.0 object library.

-and-
 * You are using the CopyFromRecordset method in your macro.



RESOLUTION
Reference the Microsoft Data Access Objects version 3.6 library rather than the DAO 3.0 library. To do this, follow these steps:
 * 1) In the Visual Basic Editor, click References on the Tools menu.
 * 2) Click to clear the Microsoft DAO 3.0 Object Library check box.
 * 3) Click to select the Microsoft DAO 3.6 Object Library check box and click OK.

Additional query words: runtime Run-time error 429 ActiveX component can t create object prb XL2002 OFFXP

Keywords: kbmacro kbdtacode kberrmsg kbprb kbprogramming KB291301

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.