Solved

MS Access "can't perform this operation" error removing object library

Posted on 2013-12-22
4
722 Views
Last Modified: 2013-12-23
Very frustrating.  I have an MS Access database application that I have connected w/ SQL Server.

It has worked fine but now the Word, Outlook and Office changed from 14 to 15 in the object library. I  guess that's because I opened it with my laptop which has Office 2013 (I have 2010).

I can't get it to go back.

I changed the Word and Office library to 14, but then I noticed i didn't move the Outlook back.  It shows as missing.

I can't drop it.  When i uncheck it and close it gives me an error saying "can't perform this ooperation".  I try every combination of dropping the three libraries but no luck.

What am I missing?
0
Comment
Question by:dougfosterNYC
  • 2
4 Comments
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
Try opening it again on your Office 2013 laptop

Go into references *on that laptop* and remove the Outlook reference

Then try it again on an Office 2010 machine, adding Outlook in as a new reference.

(not sure why, but those Outlook references seem to behave a little differently)
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
Comment Utility
Also, you might consider changing your code to "Late Binding" if your organization has a mixture of Office versions.  See the following article:
http://word.mvps.org/faqs/interdev/earlyvslatebinding.htm

There is a trade-off in  performance, but you won't have problems with references with users having different Office versions.
0
 

Author Closing Comment

by:dougfosterNYC
Comment Utility
thanks.  I can't believe i didn't think of opening it up on my laptop.

Over the years I have had to wrestle with the issue, but it was never a problem before just unchecking the MISSING references and then opening the older versions..  that threw me off.

I looked at the article and it seems like the late binding isn't a perfect fix.  The client office is all on the same version at the moment. I'm the one with the new Windows 8.1 laptop that is screwing things up.  

Thanks again.
0
 
LVL 21
Comment Utility
I looked at the article and it seems like the late binding isn't a perfect fix.  

I use later binding all the time to support mixed versions of Office without any issues I even have used with mixed versions of Office apps  on the same PC. Later binding has been the "perfect fix" for me for 1000+ users.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

743 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

13 Experts available now in Live!

Get 1:1 Help Now