XL2000: "Catastrophic Failure" Error Running Samples.xls Macro

ID: Q228633

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you run the Microsoft Visual Basic for Applications sample macro, RetrieveISAMdata() in the Sample.xls workbook that ships with Microsoft Excel and Microsoft Office, the following error message appears:

Run-time error '2147418113(8000ffff)':

Catastrophic failure

If you click Debug, the macro stops on the statement


.Open strConn

for the object:


With conn

CAUSE

This problem occurs when you run the RetrieveISAMdata() sample under the following conditions:

You run Microsoft Excel on Windows Terminal Server.

-and-

You are using Microsoft Data Access Components (MDAC) version 2.1, which ships with Office 2000.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

When you install either Microsoft Excel or Microsoft Office, the Setup program installs the sample workbook to the following folder:

C:\Program Files\Microsoft Office\Samples

NOTE: This location may be different depending on where you installed the Office program.

If you are running Microsoft Excel on Microsoft Windows Terminal Server, and you open the Samples.xls workbook, the error message appears when you click the ADO-ActiveX Data Objects worksheet, click Goto Retrieve ISAM Data Example Sample Code and then run the RetrieveISAMdata() sample macro.

Additional query words: OFF2000 XL2000

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug