Answer ID 23183  | Published 09/11/2008 04:33 PM  |  Updated 10/02/2013 11:38 AM

You have setup linked fields between Companies and Contacts. You find when you perform an update of the linked fields, some of the linked fields are not updated.

This will occur because of an issue that prevents fields in a spillover table from updating from company fields. When fields are created, they are added to a table. When a table reaches its maximize size, a new (spillover) table is created. Customers who are have numerous custom fields are more likely to experience this. This issue affects ACT! by Sage 2008 (10.0.2), (10.0.3), ACT! by Sage 2009 (11.0), and Act! v16
Note: ACT! by Sage 2009 users can resolve this issue by applying the latest update to ACT! 2009.
Please use the following Knowledgebase Answer for instructions on how to update to the latest service pack of ACT!:
How to Download and Apply the ACT! by Sage 2009 (11.1) Service Pack Answer ID: 23642

If you are an affected customer using ACT! 2008, you must download and run the DBfixer 2008 Utility to resolve this issue. If you are using Act! v16, you must download and run the DBFixer v16 Utility to resolve this issue.



    1. Right-click the version of the DBFixer file from the File Attachments area, near the bottom of this document, and then click Save Target As from the shortcut menu. A Save As dialog box appears:

    1. Click the drop-down arrow at the Save in field, browse to your Windows® Desktop, (do not rename this file), and then click Save.

It is recommended that you make a backup of your database before using this Utility. For detailed information on how to back up your database, please refer to the following Knowledgebase Answer:

Title: How to Back Up and Restore an ACT! Database Answer ID: 19211

Note: We do not warrant that the functions contained in the ACT! “Utility” will meet your needs or requirements or that installation of the “Utility will be error free. If you install a “Utility” you do so at your own risk. A 'Utility" is not supported by our technical support. THE “UTILITY” IS PROVIDED “AS IS” WITHOUT WARRANTIES OR IMPLIED TERMS OF ANY KIND, EXPRESS, IMPLIED OR STATUTORY, INCLUDING WITHOUT LIMITATION ANY WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK ARISING OUT OF THE USE OF THE “UTILITY” REMAINS WITH YOU. By downloading this file, you agree to these terms.Running the DBFixer:

    1. Close ACT!

    1. Once the file has completed downloading:ImageClick the Open button from the Download complete dialog box, or browse to your Windows Desktop and double-click the DBFixer file. The following Disclaimer box appears.

    1. Review, and then click OK. The ACT! DB Fixer Utility dialog box appears

    1. Select the name of the database you would like to run the DBFixer on, and then click the Apply button. The following DBFixer message appears.

    1. Click OK to clear the message. Repeat the above steps for all databases that you need to run this DBFixer on. Click the Close button to exit the ACT! DBFixer Utility dialog box.

    1. Launch ACT! and now you are able to successfully update all linked fields.

File Attachments

    • HTML document DBFixer 2008.exe                                                    (209.54 KB)

    • HTML document DBFixer v16.exe                                                    (108 KB)


2013-10-09 15:20:54
Comments List