ACC2000: Error Closing Access Without Saving Changes to a View (225994)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q225994
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

When you close a Microsoft Access project without having saved a view that you created by using the Query Builder, you receive one of the following error messages:
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 MSACCESS.EXE at 015f:3028b829.
NOTE: The actual memory address may vary.

With Microsoft Windows NT, you may receive an error similar to the following:
An application error has occurred and an application error log is being generated.

MSACCESS.exe
Exception: access violation (0xc0000005), Address: 0x3028b829
NOTE: The actual memory address may vary.

RESOLUTION

Save the view before closing Access, as follows. Note how the view is saved in steps 11-14.
  1. Open the sample Access project NorthwindCS.adp.
  2. On the Insert menu, click Form.
  3. In the New Form dialog box, click Form Wizard.
  4. In the Choose the table or view where the object's data comes from box, select the Customers table. Click OK.
  5. Move all fields from the Available Fields list to the Selected Fields list by clicking the >> button, and then click Finish.
  6. On the View menu, click Design View.
  7. On the View menu, click Properties.
  8. On the Data tab, click Record Source. Click the Build (...) button to start the Query Builder. The following message appears:

    Microsoft Access
    You invoked the Query Builder on a table.

    Do you want to create a query based on the table?

    Click Yes.
  9. Click to select the CompanyName field check box.
  10. On the Query menu, click Run.
  11. On the File menu, click Save to save the view.
  12. On the File menu, click Close to close the view.
  13. On the File menu, click Save to save the form.
  14. On the File menu, click Close to close the form.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Access.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample Access project NorthwindCS.adp.
  2. On the Insert menu, click Form.
  3. In the New Form dialog box, click Form Wizard.
  4. In the Choose the table or view where the object's data comes from, select the Customers table. Click OK.
  5. Move all fields from the Available Fields list to the Selected Fields list by clicking the >> button, and then click Finish.
  6. On the View menu, click Design View.
  7. On the View menu, click Properties.
  8. On the Data tab, click Record Source. Click the ellipsis (...) to start the Query Builder. Note that the following message appears:

    Microsoft Access
    You invoked the Query Builder on a table.

    Do you want to create a query based on the table?

    Click Yes.
  9. Click the CompanyName field check box.
  10. On the Query menu, click Run.
  11. Close Microsoft Access without saving the form or the view (use the Close button in the upper-right corner.) Note that you receive an invalid page fault or application error.
Modification Type:MinorLast Reviewed:7/13/2004
Keywords:kbbug KbClientServer kbpending KB225994
©2004 Microsoft Corporation. All rights reserved.