Article ID: 129769
Article Last Modified on 7/5/2002
APPLIES TO
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q129769
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you create a relationship between two attached tables, you receive the following error message:
If you choose Ignore, you can save your work in a new file, but if you choose Close, you receive a second error message:
When you close the error message window, your application terminates.
CAUSE
The above error occurs when you use any two attached tables that do not have a relationship defined in the source database.
RESOLUTION
To work around this problem, you need to upgrade your installation of Microsoft Access with the Microsoft Access version 2.0 Service Pack.
STATUS
This problem no longer occurs with the Microsoft Jet database engine version 2.5. The Microsoft Jet database engine version 2.5 is available with the Microsoft Access version 2.0 Service Pack. For information about how to obtain the Service Pack, please see the following article in the Microsoft Knowledge Base:
122927 WX1124: Microsoft Access Version 2.0 Service Pack
MORE INFORMATION
Steps to Reproduce Problem
WARNING: Following these steps will cause a General Protection Fault on your computer. Make sure you save and close any open work on your computer before following these steps.
- Start Microsoft Access and create a new database named DB1.MDB.
- Close the new database, and then open it in shared mode by making sure that the Exclusive and the Read Only check boxes are not checked.
- Import the Orders table and the Employees table from the sample database NWIND.MDB.
- Attach the Orders table and the Employees table from DB1.MDB (the database that you have open). The attached Orders table is named Orders1 and the attached Employees table is named Employees1.
- Open the Orders table.
- With the Orders table open, press the F11 key to switch to the Database window, and then choose Relationships from the Edit menu.
- In the Add Table dialog box that appears, select the Orders1 table and the Employees1 table in the Table/Query box, and then choose the Add button.
- Create a relationship between the tables by dragging the Employee ID field from the Employees1 table to the Employee ID field in the Orders1 table.
- Check the Inherited Relationship and the Enforce Referential Integrity check boxes in the Relationships dialog box, and then choose the Create button. Note that you receive the error message:
- Choose the OK button.
- Cancel the Relationships dialog box by choosing the Cancel button.
- Close the Orders table, and then repeat steps 7 and 8. Note that you receive the error messages described earlier.
REFERENCES
For more information about creating relationships, search for "relationships between tables" then "Defining Relationships Between Tables" using the Microsoft Access Help menu.
Keywords: kberrmsg kbbug kbusage KB129769