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.

About this task

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:

Procedure

  1. Open the database and select File > Application > Properties.
  2. Click the Advanced tab.
  3. Select Allow more fields in database.