Unable to set MS Access 11 Object Library after installing Office 2013

Hi Experts,

As always help with this is greatly appreciated.

I installed MS Office 2013 alongside Access 2003 and Office 2007 without any issues on my old drive and everything ran as expected. I purchased a new drive and have done a clean install missing out Office 2007 as it was no longer required. I expected everything to run fine as it did on the old drive. However, I am having a problem with the object references as follows:

In my AC2003 databases it has replaced the MS Access Object Library 11 with MS Access Object Library 15, this causes numerous problems with things not running correctly. When I try to add MS Access Object Library 11 (MSACC.olb) from the Office 11 folder it just does not add. One very odd thing as well is that when I open Access 2003 it opens OK, if I then close that and open Access 2013 that opens fine - but, it does not run the installer when switching between versions (on my old drive whenever you switched between versions the installer always ran).

The only way I can get it to load the 11 object library is by going into the Office 2013 folder and renaming the version there, this is not what I want to do everytime I switch versions.

I have to keep MS Access 2003 on my machine which I need for some of the old databases we have. I can't convert them to a newer version as other users are using them in Access 2003. I am using Windows 7 Ultimate.

I have already attempted option one and two from this site, but, it makes no difference. http://www.allenbrowne.com/bug-17.html three and four are not an option.
Ian LeasonAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<
I have to keep MS Access 2003 on my machine which I need for some of the old databases we have. I can't convert them to a newer version as other users are using them in Access 2003. I am using Windows 7 Ultimate.
>>

 The bottom line is that you cannot open any of those databases in A2013.   As soon as you do, the references are auto updated and then breaks the DB for A2003 users.  This is by design.

 Open the DB in A2003 and fix the reference, then don't open it again in A2013.

Jim.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<When I try to add MS Access Object Library 11 (MSACC.olb) from the Office 11 folder it just does not add. >>

 Sorry, I missed this.

1. Reboot the PC

2. Then open A2003.  You should see the installer switch versions.   If you don't, then run a repair on A2003, followed by a repair of A2013.

3. Open the DB with the shift key held down.

4. Do Alt/F11, tools/references, uncheck the 15.0 reference and check the 11.0 reference.  

5. Close the DB.

6. Again open with the shift key held down.

7. Ensure that the 11.0 reference is still set.

8. Do a compile and save to make sure everything is good.

Jim.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Also, since you need to operate with multiple versions, you might want to consider setting up a Virtual Machine for the A2003 or A2013 install (gets you an isolated install and out of the switching versions thing).

 Also, when you installed A2013, I hope you installed it to a directory different then that of the A2003 install.

 If you did not, then uninstall A2013, then A2003, then install A2003 followed by A2013.

Jim.
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Ian LeasonAuthor Commented:
Hi Jim,

The thing is I have never opened them in 2013 as the shortcut forces them to use AC2003 - in fact Access 2013 had never been opened at the point when I tried to do this, so it is very odd. It is the same issue if I open Ac2003 and create a new database it has the 2013 Object Ref.  Also, it won't let me add the 2003 reference, when I click to add it I don't get an error, but, it just does not add.

I have just spotted your other comments so am just heading to try that. Thank you
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
The A2003 install then is messed up.  You need to uninstall/re-install (you can try repairs first if you did use a separate directory, but if not, you cannot use repair).

Jim.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rey Obrero (Capricorn1)Commented:
just an additional step with this

< If you did not, then uninstall A2013, then A2003, then install A2003 followed by A2013.>

after UNINSTALL Reboot your PC before INSTALL

Note: 2 access version in one box does not function properly.
           I always separate them. I have a box with four operating system/multi boot and each has its own version of office.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Note: 2 access version in one box does not function properly. >>

 Um, yes and no.

While there are some rather obscure problems at times (usually with things like graph), for the most part they do work well together.

 Right now, I have one station that has A97, A2000, A2002, A2003, A2007, and A2010 all co-existing without issues.

 This is of course installing each in it's own directory and all were installed in order from oldest to newest.

 But I do agree that isolated installs is far better than not.

Jim.
Ian LeasonAuthor Commented:
I tried the repair of each first which did not make a difference, so uninstalled both versions and reinstalled which has resolved the problem Thank you for your help. Just as a side note, I had installed everything in release date order and each version of office was installed in its own directory.
Ian LeasonAuthor Commented:
I did try a multi boot machine a few years ago Rey, but, couldn't get it setup correctly. Maybe that's something I'll look at again in the future. Thanks for your comment too.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.