Product: Act! Pro, Act! Premium
Version: 2011 and later
This issue can be caused by damage to your Act! database.
There is more than one possible solution to this issue. The solutions below must be performed locally on the machine hosting the main database.
Run Database Maintenance
- Log into the database locally on the machine hosting the database. You must login in as an Administrator user in the database
- Go to the Tools menu, select Database Maintenance, then Check and Repair.
- Ensure both options are checked then run the maintenance
- When complete, go to the Tools menu, and select Synchronize With Outlook > Outlook Synchronization Preferences.
- Go to Synchronize Contacts tab, ensure that Contact Sync is enabled, and that there is a valid number for "Total number of Act! contacts to synchronize".
- Run Contact Sync to test
Detach and Reattach Database to Microsoft SQL Server®
- Close Act! on the server and have all client machines log out of the main database.
- Go to your Windows® Start Button, either click Run or go to the Search box on the Start Menu, and type actdiag. This will launch the ACT! Diagnostics utility (ACTDiag).
- In ACTDiag, go to Databases > Database List. Locate the main database on the list and click to the left of it to highlight it.
- Right-click on the database and select Detach Database. Click Yes when prompted.
- After a few moments, you will get a confirmation message and the database will disappear from the list.
- Open Act! and open your database. You will get a message that the database needs to be verified. Click OK. The database will take a minute or so to reattach to the SQL Server.
- When completed, follow Steps 4-6 in the previous solution to verify and test Outlook Contact Sync.