Microsoft KB Archive/295249

= ACC2002: Microsoft Access Hangs After You Change the Relationship for a Data Access Page =

Article ID: 295249

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295249



Moderate: Requires basic macro, coding, and interoperability skills.

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



SYMPTOMS
After you change a relationship that is made up of multiple fields in the data outline on a data access page, Microsoft Access may stop responding (hang) or may quit unexpectedly when you browse through the page.



RESOLUTION
After you change the relationship, save the page, and then quit Access before you browse through the data access page.



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



Steps to Reproduce the Behavior
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.

 Start Access. On the Help menu, point to Sample Databases, and then click Northwind Sample Database.  Create a table in Design view with the following properties, and then save it as Table1:   Table: Table1 Field Name: Key1 Data Type: Text Indexed: Yes (Duplicates OK)

Field Name: Key2 Data Type: Text Indexed: Yes (Duplicates OK)

Table Properties: Table1 PrimaryKey: Key1; Key2   Create a second table in Design view with the following properties, and then save it as Table2:   Table: Table2 Field Name: ID  Data Type: Autonumber Indexed: Yes (No Duplicates)

Field Name: Key1 Data Type: Text Indexed: Yes (Duplicates OK)

Field Name: Key2 Data Type: Text Indexed: Yes (Duplicates OK)

Field Name: Data1 Data Type: Text

Table Properties: Table2 PrimaryKey: ID                   </li> In the Database window, click Pages under Objects, and then click New.</li> Expand Table1 in the field list, and then drag the following fields to the unbound section:

Key1

Key2

</li> Expand Table2 in the field list, and then drag each field to to the unbound section.</li> When you drag the first field from Table2, the Layout Wizard starts. Click Columnar, and then click OK.</li> In the Relationship Wizard, click Key1 in the first row of the wizard on both sides of the relationship.</li> Click Key2 in the second row of the wizard on both sides of the relationship, and then click OK.</li> Drag the remaining fields from the Table2 table.</li> On the View menu, click Page View. Note that you can browse through the page without receiving an error.</li> On the View menu, click Design View.</li> On the View menu, click Data Outline.</li> In the Data Outline, right-click Table1, and then click Relationships.</li> In the Relationship Wizard, click the blank row at the top of the list in the second row of the wizard on both sides of the relationship, and then click OK to remove Key2 from the relationship.</li> On the View menu, click Page View. Note that Access stops responding when you try to browse through the page.</li></ol>

<div class="references_section">