ACC2002: Microsoft Access Hangs After You Change the Relationship for a Data Access Page (295249)


The information in this article applies to:

  • Microsoft Access 2002
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.

MORE INFORMATION

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.

  1. Start Access.
  2. On the Help menu, point to Sample Databases, and then click Northwind Sample Database.
  3. 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
  4. 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
  5. In the Database window, click Pages under Objects, and then click New.
  6. Expand Table1 in the field list, and then drag the following fields to the unbound section:

    Key1
    Key2

  7. Expand Table2 in the field list, and then drag each field to to the unbound section.
  8. When you drag the first field from Table2, the Layout Wizard starts. Click Columnar, and then click OK.
  9. In the Relationship Wizard, click Key1 in the first row of the wizard on both sides of the relationship.
  10. Click Key2 in the second row of the wizard on both sides of the relationship, and then click OK.
  11. Drag the remaining fields from the Table2 table.
  12. On the View menu, click Page View. Note that you can browse through the page without receiving an error.
  13. On the View menu, click Design View.
  14. On the View menu, click Data Outline.
  15. In the Data Outline, right-click Table1, and then click Relationships.
  16. 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.
  17. On the View menu, click Page View. Note that Access stops responding when you try to browse through the page.

REFERENCES

For more information about using the data outline, click Microsoft Access Help on the Help menu, type data outline in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbbug kbnofix KB295249
©2004 Microsoft Corporation. All rights reserved.