PERFORMANCE

Allowing more fields in a database
You can increase the number of fields in a database by selecting the advanced database property "Allow more fields in database" which allows the database to contain up to 23,000 fields.

For a database without this option selected, all the field names in a database when concatenated cannot exceed 64K, which results in a database limit of approximately 3000 fields.

To allow more fields in a database:

1. Open the database and choose File - Application - Properties.

2. Click the Advanced tab.

3. Select "Allow more fields in database."

See also