XL2000: "ActiveX component can't create object." Error Using DAO 3.0

ID: Q213577


The information in this article applies to:
  • Microsoft Excel 2000


SYMPTOMS

When you use Microsoft Data Access Objects version 3.0 (DAO 3.0) with Microsoft Excel, you may receive the following error message:

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


CAUSE

This error 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: xl2000 runtime

Keywords : kberrmsg kbprg kbdta kbdtacode xldao KbVBA xlvbmigrate
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: August 19, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.