01-19-2010 12:14 PM
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?
01-20-2010 09:42 AM
01-25-2010 08:50 AM
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?
02-16-2010 05:27 AM
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!