Solved

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

Posted on 2013-12-22
4
733 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 500 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
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…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

733 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