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" (119784)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
  • Microsoft Access 2000
  • Microsoft Access 97
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"

Modification Type:MajorLast Reviewed:3/16/2006
Keywords:kbExpertiseAdvanced kbtshoot kberrmsg kbprb kbusage KB119784 kbAudDeveloper kbAudITPRO kbAudKnowledgeWorker
©2004 Microsoft Corporation. All rights reserved.