Microsoft KB Archive/228633

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

Article ID: 228633

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q228633



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 that this is a problem in the Microsoft products that are 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: kbbug kberrmsg kbpending kbprogramming KB228633

-

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

© Microsoft Corporation. All rights reserved.