issue changing [Type] in dbo.ContactMainTable/ contacts seem to be deleted

Not open for further replies.


Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Dear BCM users,

we have a newer issue with our BCM contacts:

accounts seem to be deleted.

when looking in the dbo.ContactMainTable the account dataset is still there, but with the wrong Type. Instead of Type 2 (account contact) the Type is changed to 1 (business contact). Outlook does not show this contact, nor as account neither as business contact.

After changing the field to value '2' the account is correctly shown again by BCM Outlook Addin.

I can't understand the cause of the change. In BCM there is no way to change an account to a bussiness contact or the other way round.

Any ideas?


yes indeed, we use "Outlook Sync DB" by "Andreas Schultz Software" to sync the BCM contacts (type '7'/ projects excluded) with the "my contacts" folder of the exchange accounts. He assured us that the type field isn't been synchronised within the sql statement.
Is there any type filed at all in the exchange contact?
In a contacts folder, there isn't a 'type' field, outlook uses message class to separate it's two types- contacts and distribution list. It also supports custom fields, so software could add it and Exchange would ignore it.

Are you syncing accounts and contacts? If he isn't syncing the field but you are syncing both types, i can see that it could be possible that it's being changed during the sync.
thanks Diane,

but why it does that only in a few cases (not more than 2-3 contacts are being changed in a month in that way)? we sync every 30 minutes...

For excluding the cause you mentioned I change the sql statement for only syncing the type '1' datasets.
but why it does that only in a few cases (not more than 2-3 contacts are being changed in a month in that way)?

That is the $64M question. :) Is it always the same ones or is there a pattern? Like maybe only ones you edit on a device or outside of BCM are affected. If so, the editing process does something that makes the sync see it as a contact instead of an account.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
R Issue in changing the default account Using Outlook 4
Z Hotmail account deleted from outlook and issue with account not exist Using Outlook 0
mrrobski68 Issue with Find messages in a conversation macro Outlook VBA and Custom Forms 1
H Outlook 365 issue getting details from embedded files, crashing routine Outlook VBA and Custom Forms 0
O Mail rule issue Using Outlook 3
D Auto Remove [EXTERNAL] from subject - Issue with Macro Using Outlook 21
Commodore Safe way to add or update holidays; Windows Notifications issue Using Outlook 8
e_a_g_l_e_p_i Gmail in Outlook 2010 preview issue Using Outlook 4
M Issue transferring Outlook 2016 email accounts & settings onto new computer Using Outlook 8
P Forwarding emails issue with special characters replacing text body Using Outlook 1
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 3
A Clipboard Resize Issue Using Outlook 7
J O365 - Adding Shared Google Calendar ICS link issue in O365 Using Outlook 0
P Outlook 2013 "Item could not be moved - still an issue for Outlook 2013 Using Outlook 0
E Mail sorting view issue Using Outlook 1
D hide messege issue Using Outlook 1
B Outllok 2007 License Expired issue Using Outlook 0
ManaarZakaria I'm afraid of this issue, cause of strange error Exchange Server Administration 2
e_a_g_l_e_p_i Another reinstall of Outlook 2010 issue Using Outlook 10
Justo Horrillo Issue with rules in Outlook 2010 Using Outlook 4
G Icloud Contacts With Outlook Issue Using Outlook 4
J Contact Sync Issue Using accounts in Outlook 9
M Calendar Time Zone issue Using Outlook 0
B My outlook calendar edit issue Outlook VBA and Custom Forms 0
D Unusual calendar issue Exchange Server Administration 0
D Multiple Accounts Issue Receiving Emails in 2016 Using Outlook 0
B Winmail.dat Issue Using accounts in Outlook 0
tswatek Issue with where Outlook saves new contacts Using Outlook 3
K Outlook with MDaemon Connectivity Issue Using Outlook 4
G .ost file corrupted / solved the issue with some posts already said, but .ost file is corrupted agai Using Outlook 2
D Resizing issue for message field Outlook VBA and Custom Forms 0
P Outlook hanging issue Using Outlook 0
K Outlook 2013 calendar issue with Using accounts in Outlook 2
J Favorites in Public Folders issue Outlook VBA and Custom Forms 0
K Insert screenshots issue Using Outlook 2
B Sub Calendar-Color Coding Issue Using Outlook 4
T Using Outlook 2007 with Comcast (.pst inbox issue) Using Outlook 1
Brendan.Z Outlook 2013 signature editing issue Using Outlook 3
F Custom contact form icon issue Using Outlook 1
A Autocomplete issue Using Outlook 6
wallisellener Synch issue BCM (Business Contact Manager) 2
H Outlook 2013 size issue Using Outlook 1
C Voting Issue with Shared Inbox Using Outlook 1
J Outlook 2013 Forms Issue Using Outlook 1
M BCM remote database connection issue BCM (Business Contact Manager) 1
A How are you handling category issue and syncing Using accounts in Outlook 2
J EAS Issue Using accounts in Outlook 6
santheocles Issue in Outlook 2013 - cannot reschedule single task Using Outlook 0
P Outlook ruler issue Using Outlook 3
K Different kind of issue related to creation of archive after one has been deleted Exchange Server Administration 1

Similar threads