ACC2000: Error Saving Table Error Message After Design Change

When you try to save a table after you make a design change, you may receive the following message: This error can occur when you save a table after you make any of the following changes:

�	Add a new field
�	Add a Lookup to a field
�	Add a Description to a field

This issue can occur for either of the following reasons:

�	A large number of fields (over 150) are in the table and the field names are long (over 15 characters).
�	The Default Value property has been set for several Memo fields in a very large table.

There are several ways to resolve this issue:

NOTE: Before you try any of the methods listed below, compact your database.

Method 1

Reduce the number of fields in the table. A large number of fields indicates that the database design may be inefficient.

For additional information about database normalization, click the article number below to view the article in the Microsoft Knowledge Base: For additional information about designing a questionnaire database, click the article number below to view the article in the Microsoft Knowledge Base:

Method 2

Split the table into multiple tables and use a one-to-one relationship among the tables.

For additional information about creating relationships in a Microsoft Access database, click the article number below to view the article in the Microsoft Knowledge Base:

Method 3

Reduce the length of the field names.

Method 4

Remove the Default Value for any Memo fields in the table.