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

This article was previously published under Q213577

For a Microsoft Office XP version of this article, see 291301� (http://support.microsoft.com/kb/291301/ ) .

For a Microsoft Excel 97 version of this article, see 157436� (http://support.microsoft.com/kb/157436/ ) .

For a Microsoft Office XP version of this article, see 291301� (http://support.microsoft.com/kb/291301/ ) .

For a Microsoft Excel 97 version of this article, see 157436� (http://support.microsoft.com/kb/157436/ ) .

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.

This error message occurs when both of the following conditions are true:

Reference the Microsoft Data Access Objects version 3.6 library rather than the DAO 3.0 library. To do this, follow these steps:

In the Visual Basic Editor, click References on the Tools menu.
Click to clear the Microsoft DAO 3.0 Object Library check box.
Click to select the Microsoft DAO 3.6 Object Library check box and click OK.

Keywords: KB213577, kbprogramming, kbprb, kberrmsg, kbdtacode, kbautomation

Article Info