XL97: DAO 3.0 CopyFromRecordset Method Not Compatible with Excel 97 (157436)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q157436
For a Microsoft Office XP version of this article, see 291301.
For a Microsoft Excel 2000 version of this article, see 213577.

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

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.

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.
Modification Type:MinorLast Reviewed:10/10/2006
Keywords:kbbug kbdtacode kberrmsg kbpending kbProgramming KB157436
©2004 Microsoft Corporation. All rights reserved.