Community
Showing results for 
Search instead for 
Do you mean 
Reply

Missing records between main and remote database ACT! 2008

Tuned Listener
Posts: 4
Country: Canada

Missing records between main and remote database ACT! 2008

Hi,

 

We created a remote database to include all of the contacts in our main database, the record count is 6900.  When this remote database was restored in the laptop, the record count was roughly 300 contacts less than expected.

 

I narrowed down the group of missing contacts and tried to edit some of them them by unlinking, linking to a company add notes, history, etc.  Same result, that group will not sync with the remote database!

 

A good point though, when we add a new contact on the main database, it gets added/synchronized with the remote database.

 

 

Check and Repair, re-index was done on both tables and I even re-created the remote database but no success so far. 

 

 

Anyone else might have a fix/solution, please?

 

 

Mario

 

Copper Contributor
Posts: 386
Country: USA

Re: Missing records between main and remote database ACT! 2008

Did you confirm whether those 300 or so Contacts are PRIVATE instead of Public, or even Limited Access and this user is not included in the Users or Teams?
Kind Regards,
Renee P.J. Cronin

Sage 100 to ACT! Integration Link
Cell:717-763-8859
renee@capitolconsultingservices.com
renee@actplatinum.com
Tuned Listener
Posts: 4
Country: Canada

Re: Missing records between main and remote database ACT! 2008

Hi Renee,

 

Thanks for replying and I am sorry to get back only today (synchronization issue).  But back with the matter at hand; All contacts are public and I could not find any "contact access restriction."

 

Anything else I should check?

 

Thanks

 

Mario

Tuned Listener
Posts: 4
Country: Canada

Re: Missing records between main and remote database ACT! 2008

Well,

 

After looking for a clue as to why this is happening and short of an elegant solution, I used brute force to fix it! 

 

1. Backup of the main database.

2. Created an empty database, based on the main one.

3. I made a lookup of the non-syncing records.

4. Export the lookup to the empty database (step 2).

5. Deleted the lookup (step 3) from main database.

6. Imported back the contatcs from the empty database.

 

And Voilà, synchronization works as expected!

 

Mario