Error message after restore bckup data into new db in bcm

T

tjr

BCM with Outlook 2003 Professional I use it religiously and solely to manage
affairs in business everyday, all day I have been recording notes and phone
conversations, etc relating to my day to day business. I have always seen
"Connect to Accounting" in a drop down menu. Since I have begun I am (or was)
tracking a great amount of information in outlook and it would be nice to
have 'integration with outlook bcm 2003' and put the actual accounting data
where it should be in an accounting module or program that was supposed to
integrate with bcm, small business accounting 2006. I was intrigued and
decided to order the cd. Attempted to install the trial version of the
sba2006 and that's when it all began...

during installation of the trial version of acctg it told me that I needed
to uninstall a previously installed 'automatic update' entitled update to
msol w/bcm and sba and the dialog box assured me that the update would
reinstall automatically with this cd of sba I went to cntrl panel add remove
and uninstalled the update leaving the original program intact.

Proceded to restart the install of the sba and it opened fine. The trial
works great. It tells me that i can add customers right from accounts in
msoutlook bcm. I say great and open microsoft outlook with bcm and that's
when it got ugly.

Outlook acted as if I never initialized bcm, asking me if I wanted to use
bcm. I said yes and attempted to select or connect to an existing db. the
drop down box where I would've selected my bcm file is empty. Click connect,
still nothing.

I called Dell. Dell tells me they don't want to have me uninstall and
reinstall anything because we both see the contacts file in bcm folder and
not only that but also the backup file i created on 6-7-06. Nothing we do can
connect us to these ldf or mdf files and the backup is an msbcm file
extension not bcm as it wants in the open db dialog box. They tell me to
call Microsoft...

I read about overwriting the newly created 'empty' - I must note during
search we found an old export of contacts which imported contact names but
not the vitally important contact information stored in journal or history
(it's the box at the bottom of the contact dialog box under accounts in bcm.)
My accounts information and contacts and phone conversations, related emails,
notes etc. are all gone.

I've read all sorts of things like misdirected msde files (of which i do see
two by the way, one created long ago when I started tracking information in
bcm and one with a creation date of the installation of the trial sba) I do
not know what to do with these msde files, i have read it has something to do
with editing the registry which quite frankly freaks me out.

To add insult to injury I see the 'baronyhomescontacts' file that is the bcm
database in the same folder as some default thing that was created as a test
today and the other file in that folder is the much larger version of the
issue that has been created.

When i used the test of overwriting the data in the database from a back up
and I received the following error message. " Restore did not complete
succesfully, Line 1: incorrect syntax near "s". I had the sinking feeling of
defeat and desperation and decided to make this post in desperate hope that
you can help. This is my livelihood as I know it and tried to backup
regularly and now I am left wondering, for what?

Please help. Thank you.
 
L

Luther

Let's try an find out how BCM is currently configured.

Go to your Mail profile, Start|Control Panel|Mail|Show Profiles|Select
your profile|Properties|Data Files.

What's the filename of your BCM store?

Does that file exist in the folder specified?

If yes, we'll next have to see if its attached to your Sql Server
instance. It sounds like SBA setup detached the BCM database.

You may also want to check the microsoft.public.sba.general newsgroup.
You may not be the first person installing SBA that got their BCM
configuration hosed.
 
T

tjr

I thank you for your reply in an effort to help. I made Dell help me figure
it out and Holly M. @ dell on call was great. She helped me come to the
following resolution and was working great until...I installed 'Quickbooks'
and I am receiving the same series of error messages with a different
ending...

last new error message when trying to use bcm after installing quickbooks
(and performing the following steps) was 'can not open file' when attempting
to open an account. And now I am stumped again. However, if you do not intend
to install sba or quickbooks after resolving the issue from the first
installation the following was a great resolution...

1.) Go into bcm and create a new db.. that db needs to match the name of the
..mdf file. So, if the .mdf file is named 'MyBusiness.mdf' create a new bcm db
with that same name.

***A few points from the lesser tech minded about step 1... I tried
today after the goof with installing quickbooks and could not create a new db
in same name (even after renaming and then moving from folder) without
stoping the service mentioned in step 2 below first.

2.) Stop the MSSQL$MICROSOFTSMLBIZ Server by going to
start>run>services.msc and selecting the MSSQL$MICROSOFTSMLBIZ service (*i
add to right click the service name and select stop)

3.) Copy the original .mdf & .ldf files over the blank db. They should be in
the following location C:\Documents and Settings\<username>\Local
Settings\ApplicationData\Microsoft\BusinessContactManager

4.) Start the server again (step 2)

5.) Restart BCM and *I was able to access my database with all of my notes
and contact info, etc.

It worked for me until I was dumb enough to try it again.

My bcm is giving me a syntax error near 's' and another error message when
trying to access my accounts files (which were obviously semi restored using
the steps above- I can see the account names and bus contact names but am
unable to open the window to view all the information about the contacts and
accounts. When clicking on the account name to open I get the error message,
unable to open file.

I am hoping that you will be able to use the information posted to help
other users posting questions here and also to assist me in the issue of the
current error message. 'not opening the file'

fyi - i uninstalled the quickbooks completely, too

Thank you for your help...

tjr
 
T

tjr

how do i attach to my sql instance. files are in what i believe to be the
correct place because the steps I explained fixed it the first time... me
thinks quickbooks pulled a different 'fast-one' on my bcm...
 
T

tjr

thank you for that, however, I am afraid that you have overestimated my
understanding of all of this. Can you expound further on this command line
and how to get there in your post it just mentions the command line.

From the command line:

OSQL -E -S .\mssmlbiz -d master -Q"CREATE DATABASE MSSmallBusiness ON
(FILENAME = 'C:\Documents and Settings\luther\Local Settings\Application
Data\Microsoft\Business Contact Manager\MSSmallBusiness.mdf') FOR ATTACH"

You will need to adjust the server\instance name to your instance; e.g. the
default name with BCM v2 is microsoftsmlbiz.

Thank you again Luther. If I can see all of the account names and bus
contact names and have enabled bcm but still can't completely open the file
do you think that this is the way to go to resolve the issue?

Thanks much for your help!
 
L

Luther

So you can see the Business Contacts and Accounts in their folders, but
cannot open the forms. You get a "cannot open file" error when you try
to open a form?

Then it sounds like the database is OK.

Does the message indicate what file it cannot open?

Perhaps there is something wrong with the form files. You could try
clearing the form cache, and BCM will generate new form files.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top