Frequently asked questions for Database Admin Tool

re: Frequently asked questions for Database Admin Tool

ToughD — Mon, 02 Jun 2008 23:39:19 GMT

I installed Office Accounting 2008 on my SBS box. According to the last statement, "Also you do not need Office installed on the SBS server", I can remove Office Accounting 2008 from my SBS box?

Thank you.

re: Frequently asked questions for Database Admin Tool

bcmteam — Mon, 02 Jun 2008 23:47:31 GMT

By Office we mean Microsoft Office 2007 and not Office Accounting 2007/2008.

Thanks

Vinit [MSFT]

re: Frequently asked questions for Database Admin Tool

casaozeta — Thu, 19 Jun 2008 23:09:08 GMT

I am using Business Contact Manager (BCM) 2007. I have a shared BCM database on a Windows 2003 Server. That server's hard drive failed and the server needed to be rebuilt. I restored the BCM database to SQL Express 2005. Now in Outlook 2007 I am getting the error: "The identifier for the Business Contact Manager database has just been changed. Another user may have restored the database. Restart Outlook to connect to this database with the new identifier." Despite repeated reboots, I continue to get this error. I need to get this working. I have several users with many changes they have made to their local copy of BCM and those changes need to be sychronized with the restored BCM database on the Windows 2003 Server. Please help.

re: Frequently asked questions for Database Admin Tool

bcmteam — Fri, 20 Jun 2008 03:41:51 GMT

Please answer following questions:

1.“I restored the BCM database to SQL Express 2005.” Can you please elaborate on this?

2.Was the backup taken on a different machine from the one on which the hard drive failed?

3.What format was the backup taken in? .bak or .sbb?

4.How did you restore the database- through BCM restore or using a SQL command?

Thanks

Vinit [MSFT]

re: Frequently asked questions for Database Admin Tool

casaozeta — Fri, 20 Jun 2008 03:52:17 GMT

The BCM database was originally on the win2k box with sql 2005 express. after I removed the bad hard drive from the box, i installed a new hard drive, reinstalled win2k and sql 2005 express and used the Business Contact Manager for Outlook 2007 Database Tool to restore the database to the previous database name. it was an .sbb restore. what does the error mean? what is this "identifier for the Business Contact Manager database". how do i fix it? no matter how many times i reboot i get this error when I try to build the offline database. it appears to work fine without an offline database, but we need the offline databases. Thanks!

re: Frequently asked questions for Database Admin Tool

casaozeta — Fri, 20 Jun 2008 03:53:20 GMT

win2k above means windows 2003 server 32-bit. not windows 2000. sorry.

re: 2 questions regarding doumentation/check lists ?

Erik@MSDN — Mon, 11 Aug 2008 18:48:16 GMT

Anyone have a checklist/documents which shows steps to take to connect the local BCM-clients on the users machines to the common SQL database preferrably the SQL Express?

Also looking for documentation about what fields in the BCM-tabs (accounts, business contacts and opportunities) are adjustable and how this is done?

Kind regards

Erik

re: Frequently asked questions for Database Admin Tool

johnjm04 — Tue, 07 Oct 2008 19:44:16 GMT

john.mahoney@stainlessllc.com

email me.

is the "Add new Group" functionality in Outlook 2007 applicable to BCM in any way?

- John M.

re: Frequently asked questions for Database Admin Tool

Joe Cathey — Wed, 26 Nov 2008 03:52:36 GMT

When trying to back up the BCM database I get the following error message:

"Errors occurred during the back up of these files. The backup process has stopped."

re: Frequently asked questions for Database Admin Tool

bcmteam — Wed, 26 Nov 2008 21:32:54 GMT

Hi Joe,

Can you please turn on BCM logging and post the logs here?

To enable logging, go to Help|About Business Contact Manager for Outlook. On the dialog check the enable logging for Business Contact Manager for outlook. Then go to your user profile Temp folder and look for BCMV3.log file.

Thanks

Vinit [MSFT]

re: Frequently asked questions for Database Admin Tool

CliftonGilchrist — Tue, 09 Dec 2008 23:22:06 GMT

I am having trouble switching the database over to a new host. After I exported and imported everything, some opportunities are missing from the new host's database. It's affecting my sales numbers for the year.

Any ideas on just exporting opportunities?

Thanks,

info@capitaltrainingresources.com

re: Frequently asked questions for Database Admin Tool

bcmteam — Wed, 10 Dec 2008 01:55:30 GMT

Hi Clifton,

Did you get any errors while exporting BCM data? If you did, can you check the logs and see what went wrong?

Thanks

Vinit [MSFT]

re: Frequently asked questions for Database Admin Tool

CliftonGilchrist — Thu, 11 Dec 2008 00:08:16 GMT

I read the log and it says that they were duplicate entries, however there are varying times as well as dollar amounts assigned to the "Closed - Won" opportunities.

It seems to not like to bring over closed out opportunities period. We're missing some other records after I did the 'import and update'.

re: Frequently asked questions for Database Admin Tool

CliftonGilchrist — Thu, 11 Dec 2008 01:57:29 GMT

How are .sbb files restored?

info@capitaltrainingresources.com

re: Frequently asked questions for Database Admin Tool

mayfield — Thu, 18 Dec 2008 16:10:55 GMT

Hi BCM team

Can I clarify, can you install SQL express on any server and run the BCM database admin tool on that? Or does it have to be an SQL server? My client needs to move BCM off its SQL server and doesn't have another SQL server. They think they therefore can't host the database on any other server.

Kate

re: Frequently asked questions for Database Admin Tool

mkrtx — Wed, 24 Dec 2008 21:09:34 GMT

Hi folks - I am in process of migrating from windows xp to windows vista - i have a new laptop with vista running outlook 2003 - and do not have the old laptop which had XP

i am a heavy BCM user - so I did a "backup" from XP which created a .msbcm file

i have installed all the updates from "office update" - however, i did note it did not pick up SP4 for Outlook 2003 (KB930954)

the problem i am having is that the Import does not allow a selection of .msbcm, only .bcm

what are my options - i would be devastated to lose all that data

i also have a copy of the data on my palm 650 treo - i used chapura to sync - i have not synced that application to vista yet, so that might be an opportunity?

in advance, i appreciate any help

re: Frequently asked questions for Database Admin Tool

bcmteam — Tue, 30 Dec 2008 03:16:06 GMT

Hi,

.msbcm file is a database backup file so you'll need to restore on you new laptop and not import it.It should be under database tools.

let me know if this doesnt help.

Thanks

Vinit [MSFT]

re: Frequently asked questions for Database Admin Tool

jgs — Thu, 12 Feb 2009 00:29:02 GMT

Hi,

Every time I share a database with the database admin tool, I get the following message:

Business Contact Manager for Outlook 2007 Database Tool:

Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

The system cannot find the file specified.

It is followed by a list of details when I click on details. Then I click continue, and everything seems to be okay.

Is this something I need to worry about?

Frequently asked questions for Database Admin Tool

sreames — Sat, 21 Mar 2009 00:44:15 GMT

I am trying to install DB Admin Tool on Windows Server 2003. It asks for me to choose an SQL instance, and the only one to choose from is a pre-existing HP Web Jet Instance. Do I need to reinstall something or does selecting this SQL instance mess up the Web Jet SQL db?

re: Frequently asked questions for Database Admin Tool

bcmteam — Mon, 30 Mar 2009 21:26:58 GMT

Hi Sreames,

If you don't want to use the existing instance, you can download the free sql 2005 express edition, create a new sql instance, and use that instance instead.

Hope this helps

Thanks

-Vinit [MSFT]

re: Frequently asked questions for Database Admin Tool

garyleaf — Thu, 23 Apr 2009 00:32:40 GMT

We purchased a Windows Home Server for backup purposes. Works great for that. Now my wife wants me to create a Business Contact Manager Database on the WHS and make it accessable via remote login over the Internet. Is this even possible? I've spent hours searching for a similar question and have found nothing. If it can be done, I will need a detailed step-by-step how to. Glad to do that offline if necessary.

How Do I Remove Users with Database Admin Tool?

DPFS — Sat, 09 May 2009 02:54:25 GMT

The previous post response said:

"After deploying the database, how do I add and remove users?

The BCM database sharing wizard handles adding and removing users."

However I do not see a way to delete or remove users with the database admin tool on the machine that is hosting the database? Am i missing something?

Reporting Opportunity Notes

Trent — Thu, 14 May 2009 15:59:23 GMT

Found the question below previously in this string (dated Jan. 19, 2009 - now seems to have disappeared) but saw no responses. I have the same issue with BCM 2007 - need to include Opportunity Notes in a report - can this be done? Here's the previous question:

I am using 2007 BCM and am trying to create opportunity reports. It seems that opportunity notes from the details window are not available in the reporting options. So I want create custom reports using Access through an ODBC connection to the BCM database. Then I decided to include the user defined fields I have created but can not find what table that data in these fields is located. All I can find is the table with the field definitions but not the data fields. Can any one help?

re: Frequently asked questions for Busines Contact Manager

Lev_Bondarenko — Fri, 14 Aug 2009 09:03:40 GMT

How to filter contacts using fields of the connected account?

re: Frequently asked questions for Business Contact Manager

Lev_Bondarenko — Fri, 14 Aug 2009 09:05:24 GMT

How to add in the report programming fields?