Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. "ActiveX component can't create object" error message when you use Data Access Objects version 3.0 (DAO 3.0)

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

View products that this article applies to.

This article was previously published under Q291301
For a Microsoft Excel 2000 version of this article, see 213577� (http://support.microsoft.com/kb/213577/EN-US/ ) .
For a Microsoft Excel 97 version of this article, see 157436� (http://support.microsoft.com/kb/157436/EN-US/ ) .

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB291301, kbprogramming, kbprb, kberrmsg, kbdtacode, kbmacro

↑ Back to the top

Article Info
Article ID : 291301
Revision : 8
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 261