Microsoft KB Archive/295269

= ACC2002: Access Quits When You Are Saving a Data Access Page or Viewing It in Page View =

Article ID: 295269

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295269



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you are saving a data access page or viewing it in Page View, you receive the following error message, and then Microsoft Access quits:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.

When you view the details of the error report, you see that the error occurred in Owc10.dll.



CAUSE
You deleted a control that relies on a SchemaRowSource object to obtain its data, such as a drop-down list or list box. Then, you created another drop-down list or list box that relies on the same SchemaRowSource object, and then you selected to undo the operation.



RESOLUTION
Avoid using the Undo command to delete a newly created drop-down list or list box. Instead, manually delete the control before you view or save the page.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
A SchemaRowSource is a mechanism that a page uses to provide a list of data for controls such as drop-down lists and list boxes. A SchemaRowSource definition comes from the settings for the ListRowSource, ListBoundField, and ListDisplayField properties for these controls.

When you delete a control that relies on a SchemaRowSource, Microsoft Access does not delete the associated SchemaRowSouce, nor its subordinate SchemaFields and SchemaParameters collections. If you create another control based on the same underlying source of data, Microsoft Access replaces the original SchemaRowSource with a new one. However, during this process Microsoft Access does not properly re-create the subordinate SchemaFields and SchemaParameters collections. This causes Microsoft Access to quit whenever the data access page tries to access the SchemaRowSource's subordinate collections. This most commonly occurs when you view the data access page in Page view, or when you try to save the page.

Steps to Reproduce the Behavior
WARNING: If you follow these steps, a general protection fault will occur on your computer. Make sure that you save and then close any open work on your computer before you follow these steps.

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.


 * 1) Open the sample database Northwind.mdb.
 * 2) On the View menu, point to Database Objects, and then click Pages.
 * 3) Click New.
 * 4) In the New Data Access Page dialog box, click Design View, and then click OK.
 * 5) In the Data Access Page field list, expand the Orders table.
 * 6) Drag the OrderID and OrderDate fields onto the page.
 * 7) Drag the EmployeeID field onto the page. This creates a drop-down list that displays the employee's last name.
 * 8) Delete the Employee drop-down list that you just added to the page.
 * 9) Drag the EmployeeID field on the page a second time. Again, this creates a drop-down list that displays the employee's last name.
 * 10) On the Edit menu, click Undo Create.
 * 11) On the View menu, click Page View.

Note that you receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article, and then Access quits.

Additional query words: pra

Keywords: kbbug kberrmsg kbnofix KB295269

-

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

© Microsoft Corporation. All rights reserved.