$obsdisclaimer This can occur because the table that contains the field definitions you are attempting to modify is locked.
The error message implies that you can resize or delete fields from the table to resolve this issue. If you attempt to resize a field from this table you will receive the same error message again. This is a known issue.
When fields are created, they are added to a table. These tables can hold approximately 8000 bytes of data for defining field structures. When a table reaches its maximum size, a new (spillover) table is created. Any new fields added are placed in the spillover table(s). Full tables are locked and no modifications can be made to any field defined in the locked table(s). However, if you delete one or more fields from a locked table, you would then be able to modify the fields within that table until you reach the size limit again.
You can identify the fields that are in the table you are attempting to modify by using the Fields Detail Report in ACT! Diagnostics. Use the following steps to create a Fields Details Report:
- Click the Windows Start button, and then click Run. The Run dialog box appears.
- Type act8diag (for ACT! 2006) or actdiag (Act! 2007 and later) in the Open field, and then click OK. The ACT! Diagnostics tool Launches.
- Click the Databases option (in left toolbar or on top toolbar, depending on ACT! version).
- Select Database List and the list view appears.
- Click on the gray box to the left of the database for which you would like to run the Fields Detail Report.
- Click the Actions menu, select Database Reports, select Database Structure option, and then click Fields Detail Report. The following Database Fields Report dialog box appears:
- Click Yes. Windows Notepad launches with your report displayed:
- For each field in the table, an OLE/DB Column item is listed. The name in all caps is the name of the table containing that field. Locate the field that you wish to modify and note the name of the table it resides in (OLE/DB Column). Then locate a field in that same table that you could delete. Before you delete any fields from your database, ensure that you have a current backup. Please refer to the following Knowledge Base Answer for information on backing up your database:
Title: How to Back Up and Restore an ACT! Database
Answer ID: How to back up and restore an Act! database