Results 1 to 3 of 3
  1. #1
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,379
    Thanks
    207
    Thanked 829 Times in 762 Posts

    Dual Install Office Pro 2003 & 2010 Problems

    Here's one for those of you with 2 versions of Office installed.
    I have an Access Database will no longer startup the switchboard when opened in Office 2003, works fine in 2010. When you look at the references in the VBE it shows Access14, even though it's open in 2003 [Access12] and won't let you uncheck it because it is active. The 12 level objects do not even show up in the list. Any Ideas?

    Update: I forgot to mention that this DB also uses automation to send out Emails via Outlook and of course only Outlook 2010 is installed.
    Attached Images Attached Images
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I have 2007 and 2010 installed. When I open a db in 2007 the Reference to the Access object library is automatically changed to V12 , and when I open in 2010 they change back to 14. (2003 is Version 11 from memory.)

    What is odd in your screen shot is that the Selected Reference Access 14 is showing down the bottom (where the location is displayed) with a reference to msWord.
    WordReference.gif

    I would try a Compact and Repair or a Decompile.

    You can add References that are not listed using the Browse button, but you need to know where they are and what you are looking for, and you can't add ones that conflict with what is already there.
    Regards
    John



  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,379
    Thanks
    207
    Thanked 829 Times in 762 Posts
    John,

    It gets more interesting. I opened the file across the network on my XP machine and changed the references back.
    I'd opened Access 2003 last so now when I double click the .mdb file it opens properly and displays my switchboard.
    However, the reverences still point to the 14 level objects.

    BTW: You are correct 2003 is ver 11.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •