Office 2007 automation error library not registered

Posted on 2014-08-29
Last Modified: 2014-10-14
Hi Experts

I'm getting the following error when loading an access database:

automation error library not registered -2147319779

This is caused from previously installing office 2013 and then removing it and installing office 2007, the error occurs when a library is registered to a previous version of office, to resolve I need to remove the offending link from the registry, however the issue is identifying the correct registry key to remove?
Question by:corecc
    LVL 84
    Most errors of that nature involve bad references in the database (i.e. you're referencing a library that's not installed).

    Open the database and go to the VBA Editor, and click Tools - References. Check those to be sure none are marked as MISSING. If there are any marked as such, then you'd need to resolve those - either install the necessary files/programs to provide those references, or remove them if they're not needed.

    If none are marked as MISSING, then uncheck one of the references (be sure to note exactly which one it is), then close and reopen the References dialog, and then find and re-check the reference you removed earlier. This forces Access to recreate (and validate) the references.

    Note too that you can determine which references are needed by doing this:

    1. Compile your database - from the VBA Editor, click Debug - Compile. Fix any errors, and continue doing this until the menu item is disabled.
    2. Remove the reference - click Tools - References, and uncheck the reference
    3. Now compile the db again.

    If the database compiles in Step 3, chances are you do NOT need that reference.

    If the database does not compile, then you'd need to remake that reference.
    LVL 1

    Accepted Solution

    The solution involved clearing out all registry references to the 2013 office install
    LVL 1

    Author Closing Comment

    This resolved the issue

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    In this guide, I outline 7 key steps to help technology professionals grow their careers. Whether you have been working in technology for 10 years or for 10 days, follow these steps to help you achieve your career goals and pursue your passions.
    Not many admins are aware that GPOs can be activated and deactivated time-based. Time to change that :)
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now