Article ID: 157436 - Last Review: October 10, 2006 - Revision: 1.2

XL97: DAO 3.0 CopyFromRecordset Method Not Compatible with Excel 97

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
This article was previously published under Q157436
For a Microsoft Office XP version of this article, see 291301  (http://support.microsoft.com/kb/291301/EN-US/ ) .
For a Microsoft Excel 2000 version of this article, see 213577  (http://support.microsoft.com/kb/213577/EN-US/ ) .
Expand all | Collapse all

SYMPTOMS

When you use Microsoft Data Access Objects version 3.0 (DAO 3.0) with Microsoft Excel 97, you may receive the following error message:
Run-time error '430':
Class doesn't support Automation
Back to the top

CAUSE

You will receive the error message given above if both of the following are true:

  • You are referencing the DAO 3.0 object library.

    -and-
  • You are using the CopyFromRecordset method in your macro.
This behavior is by design of Microsoft Excel.
Back to the top

RESOLUTION

Change your project in Microsoft Excel 97 so that it references DAO 3.5 instead of DAO 3.0:

  1. In the Visual Basic Editor, click References on the Tools menu.
  2. Clear the "Microsoft DAO 3.0 Object Library" check box.
  3. Select the "Microsoft DAO 3.5 Object Library" check box and click OK.
Back to the top
APPLIES TO
  • Microsoft Excel 97 Standard Edition
Back to the top
Keywords: 
kbbug kbdtacode kberrmsg kbpending kbprogramming KB157436
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations