Office 2007 automation error library not registered

Posted on 2014-08-29
Medium Priority
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
  • 2
LVL 85
ID: 40292396
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.

Accepted Solution

corecc earned 0 total points
ID: 40371071
The solution involved clearing out all registry references to the 2013 office install

Author Closing Comment

ID: 40379417
This resolved the issue

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Web hosting control panels were first developed to make it faster and easier for most users to set up and operate websites. The graphical user interface (GUI) allows users to perform tasks by pointing and clicking rather than typing highly specific…
I came across an unsolved Outlook issue and here is my solution.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

864 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