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
 
J

John

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
 
A

AMAZINO

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
>
 
L

Luther Blissett

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
 
A

AMAZINO

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
>
 
A

AMAZINO

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.
Thread starter Similar threads Forum Replies Date
L IMAP Folders disappear from Outlook intermittently even when removed and reinstalled. Using Outlook 1
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
K Outlook 2013 - Removed Social Connector, LinkedIn and Messenger Reappear Using Outlook 7
Y Emails downloaded locally, and removed from server Using Outlook 2
B __Task 'Email removed for privacy - Sending' reported error (0x800CCC0D) : 'Cannot find the e-mail s Using Outlook 3
D Email history removed from outlook and returned to web-based mail Using Outlook 1
B Trying to find &amp; run Scanpst.exe. Outlook can't log onto server. Have removed update KB2412171 &amp; it did not correct problem. Have done a resto Using Outlook 2
U How can I restore .pst files to a now empty Outlook from which I accidently removed them? Using Outlook 1
B Error Code - Task 'Email removed for privacy' (0x80004005) : 'There is an error synchronizing your m Using Outlook 2
M MS Outlook 2007 - Auto Archive feature removed after MS update Using Outlook 1
F update 2412171 made my outlook run slow, very Email removed for privacy Using Outlook 6
C Having problems with taking items out of one folder and sending them into inbox or sending items back to my e-mail address of Email removed for privac Using Outlook 2
N Removed &amp; then added Hotmail account to Outlook. Now have multiple folders. How do I delete one? Using Outlook 4
S Restore 'Removed' mailbox Exchange Server Administration 4
M Emails being removed from the server even with the box checked to leave a copy on the server Using Outlook 1
B Task 'Email removed for privacy - Sending and Receiving' reported error (0x8DE00006) : 'The operatio Using Outlook 1
S How to set a folder in inbox to receive email from specific account?__For example Inbox-Shanthu(subfolder) has to receive email from Email removed for Using Outlook 2
A Mailbox Error - Outlook 2010 - Temporaraly Removed Error Exchange Server Administration 2
I Reminder on Sent Msg being removed upon next Send/Receive execution in Outlook Using Outlook 1
H Why do I get I get a Windows Live Alerts from Hotmail Calendar Event Reminders <Email removed for pr Using Outlook 3
L Attachments are removed in Outlook 2010 Using Outlook 6
M to bifurcate the emails from Email removed for privacy to their 3 different respective email addresses. Using Outlook 1
J __Task 'Email removed for privacy - Receiving' reported error (0x80048002) : 'This task was cancelle Using Outlook 2
D Inbox mail deleted after manually removed from server Using Outlook 5
S Database do not shrink when mails are removed Exchange Server Administration 1
P Send button is missing and account is active, can receive but can not send. Email removed for priva Using Outlook 1
H Archived Calendar Items not removed from original and entire calendar is archived not the date range specified Using Outlook 1
B After migrating users from 2003 to 2010, they are removed from custom 2003 Address Books Exchange Server Administration 1
M Client can't forget a removed mailbox it had rights to Using Outlook 2
S Intermittant problems sending mails from Qwest account (Email removed for privacy) - just started 2 days ago Using Outlook 1
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
D Outlook 2007 reinstalled, but appointments don't show in To Do bar for new calendar that was created Using Outlook 1
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
Similar threads


















































Top