Showing results for 
Search instead for 
Do you mean 

Missing Records in ACT!

New Member
Posts: 1
Country: UK

Missing Records in ACT!

Our main and remote databases synchronise fine, the problem is that the main database seems to have less records than the remote database after an hourly synchronisation is compete. In the Sync logs it says "Exceptions Occurred". I was wondering how to get both the databases to have the same amount of records when synchroinsed.


Any ideas would be lovely

Many Thanks



Nickel Elite Contributor
Posts: 595
Country: USA

Re: Missing Records in ACT!

I would suspect that the remote user has added some private contact records to their remote copy. Private records will show in the record count only for the user that made them private.
Roy Laudenslager
ACT! Certified Consultant
Nickel Super Contributor
Posts: 464
Country: Canada

Re: Missing Records in ACT!

You might want to run Actdiag on the ACT server to get an accurate record count - public, private, and/or limited access.


If you're unaware how to find this info, run "actdiag", and then select the database, right-click and select "Database Structure", and then "Table RecordsCount Reports".


Hope this helps.



Ken Quigley, BA, MCSE, ACC, APT
Toronto, Ontario
Platinum Elite Contributor
Posts: 14,524
Country: Australia

Re: Missing Records in ACT!