Microsoft KB Archive/119784

= 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.

