ACC2000: Error Closing Access Without Saving Changes to a View

ID: Q225994

The information in this article applies to:
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, the following message appears:
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 this to be 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.


Additional query words: pra adp access data project ipf 


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

Last Reviewed: May 13, 1999