Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2013-12-22
4
Medium Priority
?
756 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 39735222
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 2000 total points
ID: 39735228
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
ID: 39735862
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
ID: 39736612
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

609 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