Move shared Business Contacts Manager database to different directory

Posted on 2007-10-02
Last Modified: 2012-05-05
I just realized I made a mistake when installing BCM on our server 2003 standard, I was using my user which is an admin but it installed the bcm database into my documents and settings/user directory which it apparently then automatically shared to all the users on the server which means that now all other users have access to my directory. I want to move the database to the documents and settings/all users directory like it would have done if I'd installed it with the default Administrator account and want to know the best way to do that.
Question by:earth-traveler
    LVL 23

    Accepted Solution

    LVL 1

    Author Comment

    I believe from going through your links I found a free tool that was supposed to disconnect a bcm database, let you move it, and then reconnect it. Now I can't find it and now is when I have time to work on it. Any ideas?
    LVL 1

    Author Comment

    Actually never mind, I found it again. It's the following that I was trying to find again.

    You can shortcut the SQL command steps in the whitepaper by downloading a
    free copy of SQL Management Studio for SQL Express 2005. This allows you to
    detach a database and move it to another folder on the hard drive or a
    different PC. Then, you attach the database in its new location.
    LVL 1

    Author Comment

    This appeared to require some scripting so I ended up just uninstalling, reinstalling and reimporting my database and deleting the original. I believe I now have things set the way I want.
    Thanks for your help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
    Create high volume marketing opportunities using email signatures with these top 10 DOs and DON'Ts of email signature marketing.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now