Microsoft KB Archive/119784

Knowledge Base

Error message when you try to add tables to the Relationships window in Access: "There is not enough memory to perform this operation. Close unneeded applications and then try the operation again"

Article ID: 119784

Article Last Modified on 1/19/2007

---

APPLIES TO

• Microsoft Office Access 2003
• Microsoft Access 2002 Standard Edition
• Microsoft Access 2000 Standard Edition
• Microsoft Access 97 Standard Edition

---

This article was previously published under Q119784

SYMPTOMS

In Microsoft Office Access or in Microsoft Access, you may receive the following error message when you try to add tables to the Relationships window:

There is not enough memory to perform this operation. Close unneeded applications and then try the operation again.

CAUSE

This behavior occurs because the tables that you are adding to the Relationships window contain more than approximately 1,200 columns.

Note The exact number of columns that can appear in the Relationships window varies depending on factors such as the length of field names and the length of table names.

WORKAROUND

To work around this behavior, follow these steps in the Relationships window:

1. Delete some tables that already have defined relationships.
2. Add new tables, and then create additional relationships between the tables.

Note When you delete a table from the Relationships window, the table and its relationships are not deleted from the database. This action only removes the table from the Relationships window.

REFERENCES

For more information about the Relationships window, search Microsoft Office Access Help for the following phrase:

"Define relationships between tables"

Keywords: kbexpertiseadvanced kbtshoot kberrmsg kbprb kbusage KB119784

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.