XL97: DAO 3.0 CopyFromRecordset Method Not Compatible with XL97

ID: Q157436

The information in this article applies to:

Microsoft Excel 97 for Windows

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:

In the Visual Basic Editor, click References on the Tools menu.

Clear the "Microsoft DAO 3.0 Object Library" check box.

Select the "Microsoft DAO 3.5 Object Library" check box and click OK.

Additional query words: XL97 8.00


Keywords          : kberrmsg kbprg kbdta kbdtacode xldao KbVBA xlvbmigrate 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        :

Last Reviewed: July 2, 1999