Results 1 to 10 of 10
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Access 2003 and 2010 on same computer

    I have a computer running Access 2003. I want to install Access 2010, but I also want to keep Access 2003 on that machine. Can it be done? If so, how? (In the past I have installed a new Office application and found, too late, that it destroyed my older one. I can't afford to have that happen this time.)
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,078
    Thanks
    0
    Thanked 259 Times in 248 Posts
    A problem could exist if Access/Office 2010 is the 64-bit version, first version available as either 32-bit or 64-bit. I couldn't install Office FrontPage 2003 because of it.

    Otherwise use the Custom install for 2010 to change the install Folder and it shouldn't affect 2003 but there seems to be a lot of intermingling with Windows and/or Internet Explorer.

    The 32-bit version of Windows installs programs in C:\Program Files and the 64-bit version of Windows used C:\Program Files for 64-bit programs and C:\Program Files (x86) for 32-bit programs.
    Last edited by Berton; 2014-11-17 at 19:46.

  3. #3
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Yikes! I was afraid of something like that. Computer A runs Access, Word, Excel, and Publisher 2003 and I'm reluctant to replace them all. Computer B runs the same programs in 2010. I'm looking for a way to run my Access application from either computer. (The data will reside on one computer, while the "front end" could hopefully reside on both.)

    Since Access 2003 and 2010 use different file formats, I imagine that it's not possible to run "front ends" in two different versions accessing the same "back end" data. I may be wrong on that, though.

    Word and Excel are both OK with accessing .DOC and .XLS documents from Office 2010.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Actually, Access 2010 will happily run a .mdb database, and so will 2013. But 2003 will not be able to connect to a .accdb format database. As long as you keep using the .mdb format things will work just fine.
    Wendell

  5. The Following User Says Thank You to WendellB For This Useful Post:

    Lou Sander (2014-11-18)

  6. #5
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,078
    Thanks
    0
    Thanked 259 Times in 248 Posts
    There is a Compatibility Pack [file converter] for Office 2003, Office XP/2002 and Office 2000 to be able to use the later versions of files but it covers only Excel, PowerPoint and Word.
    https://support.microsoft.com/kb/923505?wa=wsignin1.0

  7. #6
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Wendell: Thanks! I'll give it a try.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  8. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    No problem running 2003 and 2010. I had 2003, 2007, and 2010 running on same computer.

    When installing, in addition to renaming the directory (as someone else pointed out), I think you may encounter an option to remove prior versions. Of course don't click that!

    Be advised that switching between Access2003 and 2010 will take awhile each time you do it. It's not like switching between Access 2000 and 2003.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  9. #8
    New Lounger
    Join Date
    Mar 2013
    Posts
    16
    Thanks
    0
    Thanked 1 Time in 1 Post

    Cool virtual machines

    Quote Originally Posted by Lou Sander View Post
    I have a computer running Access 2003. I want to install Access 2010, but I also want to keep Access 2003 on that machine. Can it be done? If so, how? (In the past I have installed a new Office application and found, too late, that it destroyed my older one. I can't afford to have that happen this time.)
    I no longer install more than one version of Office on a computer. Although some say it can be done successfully, it's dicey IMO. Before I started using virtual machines, I would see little incompatibilities when I co-installed versions of Office. Such things as Help not working or certain DLLs being incompatible (DLL hell).

    I use virtual machines for the past 4+ years now. The setup I've decided upon is to have the most current version of Office+Windows on my base hardware. Then for each version of Access/Office I have to support among my clients, I set up a virtual machine running Office and the version of Windows I want running with that Office. Currently my three virtual machines are Office 2003/Win 7 Pro, Office 2007/Win 7 Pro, and Office 2010/Win 7 Pro. My base machine is Office 2013/Win 8.1 Pro.

    The separation of the various Office suites is great! If two versions of Access need to get at the same file, I keep it in a shared folder on the base computer, with each virtual machine pointing at that folder too.

    I use VMware Workstation 10, but I think Hyper-V in Windows 8.1 Pro may work as well, and I think it's free; I have not explored it.

  10. The Following User Says Thank You to James Pilcher For This Useful Post:

    Lou Sander (2014-11-20)

  11. #9
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Thanks!
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  12. #10
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Thanks to everyone for their input. In the end, WendellB's reply was the most useful: I don't need the two versions of Access, since they both can handle .MDB files.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

Posting Permissions

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