?
Solved

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

Posted on 2013-12-22
4
Medium Priority
?
741 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
Suggested Courses

801 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