BCM 2007 integrated with MOA2007 shared database on SBS 2003 / SQL2005

Some accounts were merged on Wednesday before the holiday. (there
were some duplicates with different names)

Today an employee that was on Vacation last week came back to work.
He opened BCM Accounts and could not find an account. He did a search
and the account would show up.

He then noticed that his BCM was working Offline. He reconnected and
got a warning that the account he was looking for was modified while
offline in both the server and workstation.

His optinos were to keep the one that was "deleted" or keep the one
that was "modified and deleted".
He chose Modified and Deleted.

Then magically the account is gone from the main DB. Its gone...

How can I get it back? I have tons of info attached to the account
via MOA, invoices etc.

I have a PC that hasnt been synced to the shared DB. I unplugged the
network cable and opened BCM. I have the account here.

How can I "remerge" this back into BCM?

This of course happened to one of my more important and verbose
accounts.

thanks

I figured out that you can go into the actual database in the table :
ContactMainTable. There is a field called IsDeletedLocally. Set this
field to False.

Another problem is that if you delete an account it also deletes all
the Contacts attached to that account. SO you must do the same steps
as above to each contact.

On Nov 26, 12:07 pm, jointtechnologies...@gmail.com wrote:
> BCM 2007 integrated with MOA2007 shared database on SBS 2003 / SQL2005
>
> Some accounts were merged on Wednesday before the holiday. (there
> were some duplicates with different names)
>
> Today an employee that was on Vacation last week came back to work.
> He opened BCM Accounts and could not find an account. He did a search
> and the account would show up.
>
> He then noticed that his BCM was working Offline. He reconnected and
> got a warning that the account he was looking for was modified while
> offline in both the server and workstation.
>
> His optinos were to keep the one that was "deleted" or keep the one
> that was "modified and deleted".
> He chose Modified and Deleted.
>
> Then magically the account is gone from the main DB. Its gone...
>
> How can I get it back? I have tons of info attached to the account
> via MOA, invoices etc.
>
> I have a PC that hasnt been synced to the shared DB. I unplugged the
> network cable and opened BCM. I have the account here.
>
> How can I "remerge" this back into BCM?
>
> This of course happened to one of my more important and verbose
> accounts.
>
> thanks

Look in BCM's deleted items folder, find the Account, and undelete it.