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.

Related tasks
Determining the file format of a database

Help on Help

All Help Contents

Help on Help