ACC97: Error Exporting Access Table or Query to Existing Excel File with Chart Sheet

Article ID: 225353 - View products that this article applies to.
This article was previously published under Q225353
Novice: Requires knowledge of the user interface on single-user computers.

Expand all | Collapse all

On This Page

SYMPTOMS

You may experience the following problem when you export a table or query from a Microsoft Access database to an existing Microsoft Excel workbook, containing a chart sheet.
This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.
When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:
MSACCESS caused an invalid page fault in MSEXCL35.DLL at 015f:022bdf9c.
NOTE: The actual memory address may vary.

If you are using Microsoft Windows NT, you receive the following error message:
An application error has occurred and an application error log is being generated.

msaccess.exe
Exception: access violation (0xc0000005), Address 0x08f1df9c
NOTE: The actual memory address may vary.
Back to the top | Give Feedback

RESOLUTION

To prevent this problem, install Microsoft Jet 3.51 Service Pack 2.
Back to the top | Give Feedback

STATUS

This behavior no longer occurs in Microsoft Jet 3.51 Service Pack 2.
Back to the top | Give Feedback

MORE INFORMATION

This problem does not occur if the chart is embedded on a worksheet.

For additional information about the Microsoft Jet 3.51 Service Pack 2, please see the following article in the Microsoft Knowledge Base:
172733
(http://support.microsoft.com/kb/172733/EN-US/ )
Updated Version of Microsoft Jet 3.5 Available for Download

Steps to Reproduce Behavior

  1. Create an Excel file that contains a chart on a chart sheet.
  2. Save the file and close Excel.
  3. Open the sample database Northwind.mdb.
  4. Select the Shippers table.
  5. On the File menu, click Save As/Export.
  6. Choose To an External File or Database, and then click OK.
  7. In the Save as type list, select Microsoft Excel 97.
  8. Select the file that you created in step 1, and then click Export.
Note that you receive one of the errors mentioned in the "Symptoms" section.
Back to the top | Give Feedback

Properties

Article ID: 225353 - Last Review: January 24, 2007 - Revision: 3.1
APPLIES TO
  • Microsoft Access 97 Standard Edition
Keywords: 
kbbug kberrmsg kbfix KB225353
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top