Business Contact Manager corrupt database

Posted on 2011-10-18
Last Modified: 2012-05-12
I have a client who uses Business Contact Manager.  The database resides on his PC and is shared with 2 other users.  He can't add a record because it reports that he's exceeded the maximum size of 4GB (SQL Express limitation).  However, the file size is 3.4GB.  
If I select Manage Databases / Check for Errors, it returns with a message there is a problem with the data file and we need to restore.  
The most recent backup is a couple days old and it would be painful to lose those couple of days worth of data.
Does anyone have any suggestions?
Question by:rickmills
    LVL 13

    Expert Comment

    What version of SQL express?

    Author Comment

    Sorry, I should have mentioned that.  2008.
    I've restored copies of the MDF and LDF files back 2 weeks and I still get the error message telling me I need to restore.
    LVL 13

    Expert Comment

    Are there any other databases attached to SQL instance?

    Author Comment

    No.  BCM is the only SQL app on this computer.
    LVL 11

    Accepted Solution

    under the control panel-add remove programes,  click BCM and then modify...let it try to repair the install

    Just to clarify the solution, this is what I did when i faced this kind of issue:

    I was getting errors trying to uninstall .net framework so I ran the .net framework removal tool at

    I ran the tool in safemode because the computer was running very sow in normal mode, the removal tool does not use MS Installer so it will run fine in safemode but you will have to reboot into normal mode to reinstall .Net framework. I

    after rebooting I installed .NET framework, all versions up to 3.5, I did not install 4.0 because it was not installed prior. I installed them in sequence and made sure to reboot when prompted. Also, after reboot I would sometimes get an error that the installer service was already running. I opened task manager and confirmed that there were 2 msiexec processes and both were hitting the cpu, so I let them finish. This is important, do not kill the msiexec process when it is running silently in the background. Just wait until it lets you continue with the next version and then repeat.

      After I had installed all .net framework packages up to 3.5, I launched Outlook, it took a minute or two of suspense before it had opened with success and I quickly exported and backed up the database and then checked it for errors. I am just glad it wasn't a database problem. I believe the whole problem was corrupted .net framework caused by his old Norton AV software and a recent Interpolarity update caused BCM to stop functioning

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Find out how to use dynamic social media in email signatures with this top 10 DOs & DON’Ts.
    Outlook Free & Paid Tools
    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…

    779 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