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:

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