Removed and reinstalled BCM now can't see old .mdf file

Status
Not open for further replies.
P

PBKSTL

Any help would be appreciated.

I used Add/Remove programs and removed BCM completely. Stupid mistake in

trying to get the software loaded to enable synching with smartphone. I can

see the MSSmallBusiness.mdf file in the right place in my system (running

XP). It's 90MB.

I purchased a new copy of Outlook with BCM and installed the BCM part.

Outlook now has BCM, but when I go to Create New Database or Select Existing

Database, it doesn't see my old DB (where all the data is!)

I have tried multiple fixes including checking to see if SQL is started (it

is), checking the names of who has rights to access, etc. Seem to be right to

me, though I'm just a lowly salesman - not a sysadmin.

In Explorer, I'm not able to copy the .mdf file - I get an Access Denied or

Windows Encountered a Problem error. I can't open the .mdf file in Word or

Excel.

Is there a way to open that .mdf file in another program, get it into Excel

somehow, then import the data into a new BCM database? Or does anyone have

any suggestions about making BCM recognize the old DB?

Thanks,

Paul Kelly
 
On Mar 25, 3:26 pm, PBKSTL <PBK...> wrote:
> Any help would be appreciated.

> I used Add/Remove programs and removed BCM completely. Stupid mistake in
> trying to get the software loaded to enable synching with smartphone. I can
> see the MSSmallBusiness.mdf file in the right place in my system (running
> XP). It's 90MB.

> I purchased a new copy of Outlook with BCM and installed the BCM part.
> Outlook now has BCM, but when I go to Create New Database or Select Existing
> Database, it doesn't see my old DB (where all the data is!)

> I have tried multiple fixes including checking to see if SQL is started (it
> is), checking the names of who has rights to access, etc. Seem to be right to
> me, though I'm just a lowly salesman - not a sysadmin.

> In Explorer, I'm not able to copy the .mdf file - I get an Access Denied or
> Windows Encountered a Problem error. I can't open the .mdf file in Word or
> Excel.

> Is there a way to open that .mdf file in another program, get it into Excel
> somehow, then import the data into a new BCM database? Or does anyone have
> any suggestions about making BCM recognize the old DB?

> Thanks,

> Paul Kelly


Hi Paul,

Just want to double check. You mentioned that the MSSmallBusiness.mdf

is in the "right" place. Is it under your user profile (C:\Documents

and Settings\[your XP user name]\Local Setting\Application Data

\Microsoft\Business Contact Manager), or is it under another user's?

The reason I am asking is because you also mentioned that you are not

the sysadmin, so I suspected at first that the BCM database is created

by the sysadmin / located under another user's location, and that BCM

"Create or Select Database" might not be looking in the right

location. If this is the case, can you ask the other user to try re-

loading BCM?

Do you have latest BCM service patch? That might help.

With SQL Server Services, you want to make sure that the MSSMLBIZ

instance is running. There may be other instances, but those would be

less relevant to BCM.

With regards to dealing with SmartPhones, on XP I believe you would

want to look for something similar to the Windows Mobile Device Center

on Vista, instead of uninstalling/re-installing BCM.

Good luck. Once you get BCM to load your database, it is a really

good idea to do a full export and/or backup. :)

John
 
Dear John,

I have a similar problem - after a system restore I have managed to "place"

my BCM folder with the respective files in the right place (C:\Documents and

Settings\user\Local Settings\Application Data\Microsoft\Business Contact

Manager) after having to stop the SQL services to do this. The SQL services

are all running again, but BCM still refuses to see my database.

How do I go about:

- checking user priviledges

- getting BCM to see the database?

- etc to get the database running again

I am sthe system admin

Many thanks,

Andrew

"John" wrote:


> On Mar 25, 3:26 pm, PBKSTL <PBK...> wrote:
> > Any help would be appreciated.
> > I used Add/Remove programs and removed BCM completely. Stupid mistake in
> > trying to get the software loaded to enable synching with smartphone. I can
> > see the MSSmallBusiness.mdf file in the right place in my system (running
> > XP). It's 90MB.
> > I purchased a new copy of Outlook with BCM and installed the BCM part.
> > Outlook now has BCM, but when I go to Create New Database or Select Existing
> > Database, it doesn't see my old DB (where all the data is!)
> > I have tried multiple fixes including checking to see if SQL is started (it
> > is), checking the names of who has rights to access, etc. Seem to be right to
> > me, though I'm just a lowly salesman - not a sysadmin.
> > In Explorer, I'm not able to copy the .mdf file - I get an Access Denied or
> > Windows Encountered a Problem error. I can't open the .mdf file in Word or
> > Excel.
> > Is there a way to open that .mdf file in another program, get it into Excel
> > somehow, then import the data into a new BCM database? Or does anyone have
> > any suggestions about making BCM recognize the old DB?
> > Thanks,
> > Paul Kelly


> Hi Paul,

> Just want to double check. You mentioned that the MSSmallBusiness.mdf
> is in the "right" place. Is it under your user profile (C:\Documents
> and Settings\[your XP user name]\Local Setting\Application Data
> \Microsoft\Business Contact Manager), or is it under another user's?
> The reason I am asking is because you also mentioned that you are not
> the sysadmin, so I suspected at first that the BCM database is created
> by the sysadmin / located under another user's location, and that BCM
> "Create or Select Database" might not be looking in the right
> location. If this is the case, can you ask the other user to try re-
> loading BCM?

> Do you have latest BCM service patch? That might help.

> With SQL Server Services, you want to make sure that the MSSMLBIZ
> instance is running. There may be other instances, but those would be
> less relevant to BCM.

> With regards to dealing with SmartPhones, on XP I believe you would
> want to look for something similar to the Windows Mobile Device Center
> on Vista, instead of uninstalling/re-installing BCM.

> Good luck. Once you get BCM to load your database, it is a really
> good idea to do a full export and/or backup. :)
> John
>
 
On Mar 27, 3:30 am, AMAZINO <AMAZ...> wrote:
> Dear John,

> I have a similar problem - after a system restore I have managed to "place"
> my BCM folder with the respective files in the right place (C:\Documents and
> Settings\user\Local Settings\Application Data\Microsoft\Business Contact
> Manager) after having to stop the SQL services to do this. The SQL services
> are all running again, but BCM still refuses to see my database.

> How do I go about:
> - checking user priviledges
> - getting BCM to see the database?
> - etc to get the database running again

> I am sthe system admin

> Many thanks,
> Andrew

> "John" wrote:
> > On Mar 25, 3:26 pm, PBKSTL <PBK...> wrote:
> > > Any help would be appreciated.

>
> > > I used Add/Remove programs and removed BCM completely. Stupid mistakein
> > > trying to get the software loaded to enable synching with smartphone.I can
> > > see the MSSmallBusiness.mdf file in the right place in my system (running
> > > XP). It's 90MB.

>
> > > I purchased a new copy of Outlook with BCM and installed the BCM part..
> > > Outlook now has BCM, but when I go to Create New Database or Select Existing
> > > Database, it doesn't see my old DB (where all the data is!)

>
> > > I have tried multiple fixes including checking to see if SQL is started (it
> > > is), checking the names of who has rights to access, etc. Seem to be right to
> > > me, though I'm just a lowly salesman - not a sysadmin.

>
> > > In Explorer, I'm not able to copy the .mdf file - I get an Access Denied or
> > > Windows Encountered a Problem error. I can't open the .mdf file in Word or
> > > Excel.

>
> > > Is there a way to open that .mdf file in another program, get it intoExcel
> > > somehow, then import the data into a new BCM database? Or does anyonehave
> > > any suggestions about making BCM recognize the old DB?

>
> > > Thanks,

>
> > > Paul Kelly

>
> > Hi Paul,

>
> > Just want to double check.  You mentioned that the MSSmallBusiness.mdf
> > is in the "right" place.  Is it under your user profile (C:\Documents
> > and Settings\[your XP user name]\Local Setting\Application Data
> > \Microsoft\Business Contact Manager), or is it under another user's?
> > The reason I am asking is because you also mentioned that you are not
> > the sysadmin, so I suspected at first that the BCM database is created
> > by the sysadmin / located under another user's location, and that BCM
> > "Create or Select Database" might not be looking in the right
> > location.  If this is the case, can you ask the other user to try re-
> > loading BCM?

>
> > Do you have latest BCM service patch?  That might help.

>
> > With SQL Server Services, you want to make sure that the MSSMLBIZ
> > instance is running.  There may be other instances, but those would be
> > less relevant to BCM.

>
> > With regards to dealing with SmartPhones, on XP I believe you would
> > want to look for something similar to the Windows Mobile Device Center
> > on Vista, instead of uninstalling/re-installing BCM.

>
> > Good luck.  Once you get BCM to load your database, it is a really
> > good idea to do a full export and/or backup. :)
> > John-




Try attaching the database to the sql instance directly. It may then

show up as available in BCM.

http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html
 
Luther,

thanks for your reply - have you a "instructions for dummy´s" on how to find

this comand string and change it?

I installed the free "SQL Server Managerment Sutidio Express" from MS

website and also have installed the "SQL Server 2005 configuration manager"

> ... but don´t know how to use either :(

"Luther Blissett" wrote:


> On Mar 27, 3:30 am, AMAZINO <AMAZ...> wrote:
> > Dear John,
> > I have a similar problem - after a system restore I have managed to "place"
> > my BCM folder with the respective files in the right place (C:\Documents and
> > Settings\user\Local Settings\Application Data\Microsoft\Business Contact
> > Manager) after having to stop the SQL services to do this. The SQL services
> > are all running again, but BCM still refuses to see my database.
> > How do I go about:
> > - checking user priviledges
> > - getting BCM to see the database?
> > - etc to get the database running again
> > I am sthe system admin
> > Many thanks,
> > Andrew
> > "John" wrote:
> > > On Mar 25, 3:26 pm, PBKSTL <PBK...> wrote:
> > > > Any help would be appreciated.

> >
> > > > I used Add/Remove programs and removed BCM completely. Stupid mistake in
> > > > trying to get the software loaded to enable synching with smartphone. I can
> > > > see the MSSmallBusiness.mdf file in the right place in my system (running
> > > > XP). It's 90MB.

> >
> > > > I purchased a new copy of Outlook with BCM and installed the BCM part..
> > > > Outlook now has BCM, but when I go to Create New Database or Select Existing
> > > > Database, it doesn't see my old DB (where all the data is!)

> >
> > > > I have tried multiple fixes including checking to see if SQL is started (it
> > > > is), checking the names of who has rights to access, etc. Seem to be right to
> > > > me, though I'm just a lowly salesman - not a sysadmin.

> >
> > > > In Explorer, I'm not able to copy the .mdf file - I get an Access Denied or
> > > > Windows Encountered a Problem error. I can't open the .mdf file in Word or
> > > > Excel.

> >
> > > > Is there a way to open that .mdf file in another program, get it into Excel
> > > > somehow, then import the data into a new BCM database? Or does anyone have
> > > > any suggestions about making BCM recognize the old DB?

> >
> > > > Thanks,

> >
> > > > Paul Kelly

> >
> > > Hi Paul,

> >
> > > Just want to double check. You mentioned that the MSSmallBusiness.mdf
> > > is in the "right" place. Is it under your user profile (C:\Documents
> > > and Settings\[your XP user name]\Local Setting\Application Data
> > > \Microsoft\Business Contact Manager), or is it under another user's?
> > > The reason I am asking is because you also mentioned that you are not
> > > the sysadmin, so I suspected at first that the BCM database is created
> > > by the sysadmin / located under another user's location, and that BCM
> > > "Create or Select Database" might not be looking in the right
> > > location. If this is the case, can you ask the other user to try re-
> > > loading BCM?

> >
> > > Do you have latest BCM service patch? That might help.

> >
> > > With SQL Server Services, you want to make sure that the MSSMLBIZ
> > > instance is running. There may be other instances, but those would be
> > > less relevant to BCM.

> >
> > > With regards to dealing with SmartPhones, on XP I believe you would
> > > want to look for something similar to the Windows Mobile Device Center
> > > on Vista, instead of uninstalling/re-installing BCM.

> >
> > > Good luck. Once you get BCM to load your database, it is a really
> > > good idea to do a full export and/or backup. :)
> > > John-

>


> Try attaching the database to the sql instance directly. It may then
> show up as available in BCM.
> http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html
>
 
I have found the solution

http://www.mydatabasesupport.com/fo...ach-sql2005-database-different-directory.html

QUOTE:

Use SQL Server configuration manager from SQL Server 2005 program

goups...There select sql server 2005 services and choose sql server service

and see the Logon account.

If the account is not local system then change it to Local system and then

restart the service and see if the attch works. If it works then give the

necessary previlages to the

toher account and restart the service and see if the attach works fromm D

Drive..

Thanks

Hari

"AMAZINO" wrote:


> Luther,

> thanks for your reply - have you a "instructions for dummy´s" on how to find
> this comand string and change it?

> I installed the free "SQL Server Managerment Sutidio Express" from MS
> website and also have installed the "SQL Server 2005 configuration manager"
> ... but don´t know how to use either :(

> "Luther Blissett" wrote:
>
> > On Mar 27, 3:30 am, AMAZINO <AMAZ...> wrote:
> > > Dear John,
> > > > I have a similar problem - after a system restore I have managed to "place"
> > > my BCM folder with the respective files in the right place (C:\Documents and
> > > Settings\user\Local Settings\Application Data\Microsoft\Business Contact
> > > Manager) after having to stop the SQL services to do this. The SQL services
> > > are all running again, but BCM still refuses to see my database.
> > > > How do I go about:
> > > - checking user priviledges
> > > - getting BCM to see the database?
> > > - etc to get the database running again
> > > > I am sthe system admin
> > > > Many thanks,
> > > Andrew
> > > > > > "John" wrote:
> > > > On Mar 25, 3:26 pm, PBKSTL <PBK...> wrote:
> > > > > Any help would be appreciated.
> > > > > > I used Add/Remove programs and removed BCM completely. Stupid mistake in
> > > > > trying to get the software loaded to enable synching with smartphone. I can
> > > > > see the MSSmallBusiness.mdf file in the right place in my system (running
> > > > > XP). It's 90MB.
> > > > > > I purchased a new copy of Outlook with BCM and installed the BCM part..
> > > > > Outlook now has BCM, but when I go to Create New Database or Select Existing
> > > > > Database, it doesn't see my old DB (where all the data is!)
> > > > > > I have tried multiple fixes including checking to see if SQL is started (it
> > > > > is), checking the names of who has rights to access, etc. Seem to be right to
> > > > > me, though I'm just a lowly salesman - not a sysadmin.
> > > > > > In Explorer, I'm not able to copy the .mdf file - I get an Access Denied or
> > > > > Windows Encountered a Problem error. I can't open the .mdf file in Word or
> > > > > Excel.
> > > > > > Is there a way to open that .mdf file in another program, get it into Excel
> > > > > somehow, then import the data into a new BCM database? Or does anyone have
> > > > > any suggestions about making BCM recognize the old DB?
> > > > > > Thanks,
> > > > > > Paul Kelly
> > > > > Hi Paul,
> > > > > Just want to double check. You mentioned that the MSSmallBusiness.mdf
> > > > is in the "right" place. Is it under your user profile (C:\Documents
> > > > and Settings\[your XP user name]\Local Setting\Application Data
> > > > \Microsoft\Business Contact Manager), or is it under another user's?
> > > > The reason I am asking is because you also mentioned that you are not
> > > > the sysadmin, so I suspected at first that the BCM database is created
> > > > by the sysadmin / located under another user's location, and that BCM
> > > > "Create or Select Database" might not be looking in the right
> > > > location. If this is the case, can you ask the other user to try re-
> > > > loading BCM?
> > > > > Do you have latest BCM service patch? That might help.
> > > > > With SQL Server Services, you want to make sure that the MSSMLBIZ
> > > > instance is running. There may be other instances, but those would be
> > > > less relevant to BCM.
> > > > > With regards to dealing with SmartPhones, on XP I believe you would
> > > > want to look for something similar to the Windows Mobile Device Center
> > > > on Vista, instead of uninstalling/re-installing BCM.
> > > > > Good luck. Once you get BCM to load your database, it is a really
> > > > good idea to do a full export and/or backup. :)
> > > > John-

> > >

> > Try attaching the database to the sql instance directly. It may then
> > show up as available in BCM.
> > http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html
> >
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
K Gmail not removed from server Using Outlook 3
M icloud removed my contacts Using Outlook 7
P "Edit Message" feature removed in Outlook 2016 for Mac Outlook VBA and Custom Forms 0
A Calendar Reminders are Removed with Sync to Outlook.com Using Outlook.com accounts in Outlook 11
T Outlook removed my emails from my server Using Outlook 1
R How do I recover emails removed by Outlook because of IMAP? Using Outlook 1
W text to show removed attachments in an e-mail chain Exchange Server Administration 1
V Maintain name of removed attachments - how to? Using Outlook 9
J “additional” mailbox cannot be removed from an Outlook 2007 client’s mailbox Exchange Server Administration 1
kburrows Outlook 2013 - Removed Social Connector, LinkedIn and Messenger Reappear Using Outlook 7
Y Emails downloaded locally, and removed from server Using Outlook 2
S Original Attachment not removed Outlook VBA and Custom Forms 4
jobudge Reinstalled Outlook 2013 after system crash what is best way to synch with gmail? Using Outlook 1
T Reinstalled OL2010 now have 3 separate inboxes and contacts missing Using Outlook 2
T Outlook 2010 BCM Migration to Standard Contacts BCM (Business Contact Manager) 0
R Follow up button doesn't working neither the reminders in BCM BCM (Business Contact Manager) 0
P BCM conditional formatting BCM (Business Contact Manager) 5
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
D BCM 2013 not functioning as BCM 2010 Example no drop down for communications history Using Outlook 0
J No access to a Database BCM BCM (Business Contact Manager) 3
J Marketing task MS BCM BCM (Business Contact Manager) 10
S BCM Compulsory field, New opportunity Outlook VBA and Custom Forms 0
A BCM does not work anymore! BCM (Business Contact Manager) 1
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
A BCM does not work with Windows 10 1703 any more BCM (Business Contact Manager) 3
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
S BCM Project Task Order BCM (Business Contact Manager) 1
T Lost access to remote BCM database BCM (Business Contact Manager) 4
crazyboy Problems connecting to BCM on Server Using Outlook 2
J Problems connecting to BCM BCM (Business Contact Manager) 16
T BCM 2010 randmoly going offline BCM (Business Contact Manager) 0
M At last a BCM alternative... Outlook Customer Mngr 365! BCM (Business Contact Manager) 0
S BCM view customization BCM (Business Contact Manager) 1
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
K BCM Reports: Timeout Expired BCM (Business Contact Manager) 0
K BCM hide subfolders BCM (Business Contact Manager) 1
Diane Poremsky Restoring BCM Database After Upgrading Windows Using Outlook 0
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Diane Poremsky Trial/Beta program for BCM replacement BCM (Business Contact Manager) 8
A BCM crashes immediately after start BCM (Business Contact Manager) 2
A Two Problems with BCM BCM (Business Contact Manager) 0
J BCM 2013 displays wrong form for account and business contact BCM (Business Contact Manager) 1
A Latest updates kill BCM 2013 BCM (Business Contact Manager) 0
C Where are BCM User Customizations located? BCM (Business Contact Manager) 9
Diane Poremsky Outlook 2016: No BCM Using Outlook 0
Diane Poremsky Outlook 2016: No BCM BCM (Business Contact Manager) 17
wallisellener BCM and MSSQL2012 BCM (Business Contact Manager) 2
M Can I use BCM projects for this BCM (Business Contact Manager) 1
R BCM Reporting of repeat calendar entries BCM (Business Contact Manager) 0

Similar threads

Back
Top