Microsoft KB Archive/225994

= ACC2000: Error Closing Access Without Saving Changes to a View =

Article ID: 225994

Article Last Modified on 7/13/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.  Open the sample Access project NorthwindCS.adp. On the Insert menu, click Form. In the New Form dialog box, click Form Wizard. In the Choose the table or view where the object's data comes from box, select the Customers table. Click OK. Move all fields from the Available Fields list to the Selected Fields list by clicking the >> button, and then click Finish. On the View menu, click Design View.</li> On the View menu, click Properties.</li> 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.</li> Click to select the CompanyName field check box.</li> On the Query menu, click Run.</li> On the File menu, click Save to save the view.</li> On the File menu, click Close to close the view.</li> On the File menu, click Save to save the form.</li> On the File menu, click Close to close the form.</li></ol>

<div class="status_section">

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

<div class="moreinformation_section">

Steps to Reproduce Behavior
<ol> Open the sample Access project NorthwindCS.adp.</li> On the Insert menu, click Form.</li> In the New Form dialog box, click Form Wizard.</li> In the Choose the table or view where the object's data comes from, select the Customers table. Click OK.</li> Move all fields from the Available Fields list to the Selected Fields list by clicking the >> button, and then click Finish.</li> On the View menu, click Design View.</li> On the View menu, click Properties.</li> <li>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.</li> <li>Click the CompanyName field check box.</li> <li>On the Query menu, click Run.</li> <li>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.</li></ol>

Additional query words: pra adp access data project ipf msaccess exe

Keywords: kbbug kbclientserver kbpending KB225994

-

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

© Microsoft Corporation. All rights reserved.