Microsoft KB Archive/157436

= XL97: DAO 3.0 CopyFromRecordset Method Not Compatible with Excel 97 =

Article ID: 157436

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



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.

Additional query words: XL97 8.00 Run-time error 430 Class doesn t support Automation

Keywords: kbbug kbdtacode kberrmsg kbpending kbprogramming KB157436

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.